Import CSV files to a table

[Jens Süßmeyer]

Hello Rog !

From BOL (just read the explanations about BULK INSERT)

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

HTH, Jens Süßmeyer.

"Rog" <rfed...@maimonidesmed.org> schrieb im Newsbeitrag
news:021b01c367fa$6fd12bd0$a101...@phx.gbl...
> Hi,
> How do I automatically import csv files to a table.
>
> Thanks in advance

[Gandhinath Swaminathan(MS)]

http://support.microsoft.com/default.aspx?scid=kb;en-us;198891 has some
useful information. Hope that helps.

--

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/copyright.htm.
"Rog" <rfed...@maimonidesmed.org> wrote in message

[Vinodk]

You can do this using a linked server like in
http://www.extremeexperts.com/sql/articles/ExcelLinkedServer.aspx. Here you
need to just insert it into a table.
You can also use the bulk insert method as in
http://www.extremeexperts.com/sql/articles/SimpleBulkInsert.aspx.

--
HTH,
Vinod Kumar
MCSE, DBA, MCAD
www.extremeexperts.com