Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-31 : 09:13:22
|
| Ram writes "I need to export the sql data to MS Access database programmatically using ASP. Can anyone suggest me the fastest method to do this. Thanks for your help." |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-05-31 : 10:51:15
|
| If the server that is running your ASP code has access to DAO, you can use DAO to do this.*************************Someone done told you wrong! |
 |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2002-05-31 : 14:38:49
|
| If you're using SQL2000 and are new to DTS the you can create a DTS package and then do a package.[save as] then select the Location field and pull down [visual basic file]. This will give you most of the code that you will need. You can also create a package (a simple export) by right-clicking on the SQL Table and then select [all tasks].[export data]. Once you have completed the wizard you then have the option to save it as a visual basic file. You want quick, right?HTHJamesH. |
|
|
|
dataphile
Yak Posting Veteran
71 Posts |
Posted - 2002-06-03 : 08:24:27
|
| You could create a linked server for access using the ole db provider for odbc. Then create a stored procedure that populates the Access linked server. Then just execute the stored procedure from the shortest ASP page ever. |
|
|
|
dataphile
Yak Posting Veteran
71 Posts |
Posted - 2002-06-04 : 05:48:42
|
| See:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=16453[/url] |
|
|
|
|
|
|
exporting sql data to MS Access programmatically