export data from SQL to Access using ASP

[Joanna]

Hi,
Is there anyone can help me?
How can I export data from SQL to Access in the ASP file? Is it possible?
Thanks!
Joanna

[Mad]

Design a DTS package to export Data from SQL to Access. Develop a Wrapper stored procedure to execute DTS package.

You can finally execute Stored procedure from ASP.

I am not sure what are all the clauses which you have to export the data? Is it a daily activity?

Mad


------------
Joanna at 5/10/01 9:46:27 AM

Hi,
Is there anyone can help me?
How can I export data from SQL to Access in the ASP file? Is it possible?
Thanks!
Joanna

[Joanna]

Hi,
Thanks for your reply, let me tell you more detail:
we want to let the user click a button in the ASP file, then export everything in the SQL Server to Access. Because, user want to generate the report in the Access.
Do you have any suggestion?
Thanks!
Joanna

------------
Mad at 5/10/01 9:49:19 AM

Design a DTS package to export Data from SQL to Access. Develop a Wrapper stored procedure to execute DTS package.

You can finally execute Stored procedure from ASP.

I am not sure what are all the clauses which you have to export the data? Is it a daily activity?

Mad


------------
Joanna at 5/10/01 9:46:27 AM

Hi,
Is there anyone can help me?
How can I export data from SQL to Access in the ASP file? Is it possible?
Thanks!
Joanna

[Jesal]

If the database design is identical in both the database then there is no issues
otherwise I would export it to CSV format and then call a Executable to insert it into Access


------------
Joanna at 5/10/01 9:46:27 AM

Hi,
Is there anyone can help me?
How can I export data from SQL to Access in the ASP file? Is it possible?
Thanks!
Joanna