Stored Procedure to Import Tab-Quote Delimited File into Table

[dpgirl]

Could someone help me write a stored procedure that will take a tab-quote delimited file (with header) and load it into a table? Thanks in advance!

Here's some sample data from the text file:

"Name" "Value"
"Brian McMillen" "1722"
"Anthony Adams" "8532"
"Erik Jenner" "7209"
"Terrance Walker" "1873"

 

[jbenson001]

You can use DTS to import or the Import/export wizard.

 

[dpgirl]

Yes, I'm aware that I can use DTS but I have a million files to load so I'd like a stored procedure to make it easier. I will combine this procedure with another procedure that will automatically load all files within a particular folder so I don't have to specify each filename to load.

 

[harebrain]

Try starting here: thread183-626356

Now all you have to do is strip the quotes.