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 |
|
craigfw
Starting Member
8 Posts |
 Posted - 2004-08-16 : 12:41:55
|
| I'm trying to load table data imported from Access into Excel tables (with identical table names) into a SQL Server. The load utility in either MS SQL Manager using DTS Import or DB Artisan Load runs but no rows are loaded. I've tried bcping the data using Artisan (comma delimiter), but that doesn't work either. I could really use some of the DBA magic everyone has out there. This is really burning up alot of time...... |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-08-16 : 12:45:16
|
| insert it from access...what error messages do you get when importing?Go with the flow & have fun! Else fight the flow :) |
 |
|
|
craigfw
Starting Member
8 Posts |
Posted - 2004-08-16 : 13:00:45
|
| It's saying that it can't find the database file (then shows the path right to the file. |
|
|
|
|
|
|
Excel Table to SQL table Load...