Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Thu, Jan 31 2008 11:59 AM	Permanent Link
Scott Woods	I am importing a CSV file into a table that has dates. I assume the dates are text in the CSV. The dates are never imported into a field of type Date in the DB. All other fields are imported. Is this an issue or is there a work around? Thanks Scott
Thu, Jan 31 2008 5:11 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Scott, << I am importing a CSV file into a table that has dates. I assume the dates are text in the CSV. The dates are never imported into a field of type Date in the DB. All other fields are imported. Is this an issue or is there a work around? >> Are you using column headers in the import file ? If any column headers don't match the existing column names, then that column of data won't be imported. -- Tim Young Elevate Software www.elevatesoft.com
Mon, Feb 4 2008 12:34 AM	Permanent Link
"Scott Woods"	This was my fault - I had the wrong date format selected on the import dialogs second tab. Sorry.