-
export data from SQL to Access using ASP
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
-
export data from SQL to Access using ASP (reply)
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
-
export data from SQL to Access using ASP (reply)
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
-
export data from SQL to Access using ASP (reply)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|