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 |
|
edp1959
Starting Member
1 Post |
Posted - 2004-06-03 : 09:04:58
|
| I would like to bulk insert data from an Access (2000) database table into a SQL table. Can someone help me with a stored procedure that will do this?Thanks |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-06-03 : 13:07:43
|
| You cannot BULK INSERT from Access ... only from a text file.Consider using a linked server ... or DTS.Jay White{0} |
 |
|
|
|
|
|