Import a CSV using Stored Procedures

[penguin321]

Sorry if this has been covered before, but is there a way to import a CSV file using stored proecedures. We have a nightly routine which updates data into SQL, and part of that routine will require reading from a CSV or TXT file. I'm hoping to use what SQL already has available instead of writing my own code to parse the file, etc.

Any help would be appreciated. Thanks.

 

[sunaj]

Hi,

Yes it's possible using the BULK INSERT with the 'formatfile' option. You can use teh bcp program to generate a formatfile for your table & input file.
Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[tlbroadbent]

Most of the time, when using BULK INSERT to import CSV files no format file is required. See SQL Books Online for details or use the following link.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_ba-bz_4fec.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.