First i create a table in MS SQL:
create table beliggenhet
(Beliggenhetsnummer int UNIQUE,
That code is working fine...
Textfile lock like this:
1,"This is a test","Is this working","AQ"
2,"Working fine","Or not","AX"
The text file must lock like:
1,This is a test,Is this working,AQ
2,Working fine,Or not,AX
But the code :
firstrow = 1,
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
give me alot of errors.
This distributions is " in the file ...
How do i remove " from file ?
Onother problem is that, next time i read the table. It maby content
a field that alredy exist in the table beliggenhet. So it must just update the
table, not Insert..
Hope sombody can help me solve this issue.