Hi there all
Don't know if I'm at the wrong place, but I'll take that chance.
I am fed up battling with importing txt files to sql server 2005. I am re-writing a vb6 based application, that uses text files, to a c# based application that uses sql server 2005 as a database.
In sql server I use the import/exprot wizard to import the flat file. All worked fine for the first two text files, vechiles and users, but now the rest doesn't work at all. I tried converting to csv and then importing but nothing. It just keeps on giving me errors.
What I am trying now is perhaps replace the row delimeters from %#% to '.
Any suggestions will be usefull
Thanks