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 |
|
arthiasha
Starting Member
40 Posts |
 Posted - 2012-10-30 : 05:16:33
|
| Hi experts,I have a .csv file from which i have to do bcp out and bcp in, in command prompt and store the data into a table called temp.How do i get the data into the table from a .csv file?I have created the datafile and format file for temp.How to get the values from .csv file and do bcp in to load it into the table 'temp'?Please help meThanks in advance |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-10-30 : 07:09:31
|
| Look at the examples on this page and modify it to your situation. There are a number of examples there including creating a format file, using a format file to import data etc. http://msdn.microsoft.com/en-us/library/ms162802.aspx |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2012-10-30 : 07:56:56
|
| Is there a reason you must use bcp? but something like thisbcp [dbname].schema.table in 'c:\test.csv' -T |
|
|
|
|
|
|
bcp out from .csv to sqlserver table