Hi,
I'm trying to import some data from a CSV file into a table in SQL server. At around row 40.000 SQL server gives an error. It says: Column delimiter not found. I think that there went something wrong creating the CSV file. I thought of just opening the CSV file en checking it by hand but it is to big to open. Does anyone know if there i a way to check a CSV file with a program or something?
JoachimYou can try using MS Access. Create the same table etc. Try importing your csv again and it should discard any invalids rows. Or try and achieve that with a DTS job
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment