Member Avatar for questionary

Hi.

I am trying to load data from text file do table by BULK INSERT query. Command crashes on loading date field from text file to db. In the file there is a column where date is stored in the following format: Mar 18 2008 3:40:25:153PM. The type of the column where date from file goes is datetime. Why I am still getting an error Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 6 (row_dt). - sixth column stores date...

help please

  • 2 Contributors
  • 1 Reply
  • 83 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by Geek-Master
Member Avatar for Geek-Master

Open your source file in a spreadsheet program like Microsoft Excel or OpenOffice.org CALC and change the date/time field to something more common like 03/18/2008 15:40:25:153 instead of the calendar names.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.