Posted by Michael Houmaark on 10/13/05 20:54

Hi

I have a text file with this information
-BEGIN----------------- tekst.txt-------------
10, "firstname", "lastname"
11, "Mette", "Larsen"
--| |--
6 000 000, "Michael", "Houmaark"
-END-------------------- tekst.txt-------------

I use this SQL-query
-BEGIN------------------SQL--------------
bulk insert tlf.dbo.bruger_data from 'C:\TEKST.txt'
with
(
FIRSTROW = 1,
FIELDTERMINATOR = '";"',
ROWTERMINATOR = '"\n'
)
-END--------------------SQL--------------


But when the data is in the table its still have the " arround the firstname
and lastname
what do I do ?????

Best Regards
Michael H

[Back to original message]