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 |
|
JsonTerre1
Starting Member
9 Posts |
 Posted - 2009-01-04 : 19:22:15
|
| I have to use classic asp to do bulk insert from MS SQL to MS Access. Does anyone have code that does this. I need to do this without looping through the data. j |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-04 : 22:33:34
|
| Your question is not clear. You can use SSIS packages if you want to migrate data from SQL to Access. |
 |
|
|
JsonTerre1
Starting Member
9 Posts |
Posted - 2009-01-05 : 09:11:30
|
| everything is hosted through a 3rd party comapny so i can't use SSIS because they won't give me access to a directory on the webserver.In classic asp i have a recordset from an MS SQL pull. I want to take that recordset and bulk insert it into an MS Access DB from my classic asp script. I hope that is clearer.j |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-05 : 09:24:27
|
quote:
Originally posted by JsonTerre1
everything is hosted through a 3rd party comapny so i can't use SSIS because they won't give me access to a directory on the webserver.In classic asp i have a recordset from an MS SQL pull. I want to take that recordset and bulk insert it into an MS Access DB from my classic asp script. I hope that is clearer.j
isnt it enough to upload your recordset as a file through asp page. then write code at your backend to bulk upload this files data onto sql table using bulk insert statement |
|
|
|
|
|
|
Bulk Insert from SQL to Access