|
|
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
Navigation:
[Reply to this message]
|