Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    The Netherlands, Oudkarspel

    Unanswered: checking a CSV file


    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?


  2. #2
    Join Date
    Feb 2003
    Brisbane, Australia

    Re: checking a CSV file

    You 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts