var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Load data from comma delimited text file
Hello, i need to load some data from a long comma delimited text file, How can a i do that, using t-sql?, thanks for your help!!!!!
what do you mean "long"? is there a row delimiter in the file?
the file has 25.000 ++ rows, and yes, is comma delimited!
click the start button on your desktop and then click run
in the run dialog box type dtswiz
when the import export wizard opens up perform the following tasks..
set the source as your text file
set the destination as your table
set any transformations
save this as you need to ( i always save to a com storage file)
schedule if you need to
Bulk Insert yourtable
With (FieldTerminator = ',',
RowTerminator = ',\n',
CodePage = 'ACP',
Thanks for your suggestion
The bulk insert is that i was looking for. Thanks for your help!!!