importing a comma delimmited file into sql server

[pink2070]

This is new to me, How do I import a comma delimmited file into sql server.

If you have any code snippets or site recommendatins they would be greatly appreciated

Thank you very much

Pink

 

[chrissie1]

me i do it on the sql-server via a dts package because if you do it locally and the user has other settings for , or . it doesnt work anymore.

just my 2 cents worth

Christiaan Baes
Belgium

What a wonderfull world - Louis armstrong

 

[SqueakinSweep]

Check out the BULK INSERT Command.
Look up the Help on this within SQL Server itself.

BULK INSERT Northwind.dbo.[Order Details]
   FROM 'f:\orders\lineitem.tbl'
   WITH 
      (
         FIELDTERMINATOR = '|',
         ROWTERMINATOR = '|\n'
      )

Sweep
...if it works dont mess with it