I have to figure out how to transfer a bunch of Access tables out to SQL Express. The first attempt will be to use BCP.
I tried with one of the smaller tables first.
Export to textfile --> CSV
Use BCP to import to pre-built SQL table with same schema.
No worky...
SO,
I created a simple text file with 2 rows, comma separated (4 'fields')
ie;
Bob, Smith, 33, Large
Bill, Jones, 44, Small
I have a table in SQL with 4 fields, all varchar(50)
The bcp command I am using appears to connect to sql no problem, but when all is said and done I get this:
0 rows copied.
Network packet size <bytes> 4096
Here is my cmd line code:
CODE
bcp [ImportTest].[dbo].[tbl_Import] in C:\ExpTest\test.txt -T -S n_laptop\sqlexpress
I have tried all 4 switches (-w,-c,-n,-N) as well as no switches at all
NOTHING WORKS!
Kinda grumpy... any ideas?
Thanks.
20 Jun, 2008 - 03:20 PM
|