By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,871 Members | 2,444 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,871 IT Pros & Developers. It's quick & easy.

Importing a CSV file with a Date/Time field, the field nulls itself out

100+
P: 133
I currently importing a csv file with an import specification declaring the field values. one field is a date/time field. when the csv file is imported, it clears the date field with null values. the code is listed below.

Any suggestions?

As a work around, the import specification declares the date field as a text to maintain the values. thereafter, the data is inserted into a new table with the date field updated with the CDate function.

Expand|Select|Wrap|Line Numbers
  1. DoCmd.TransferText acImportDelim, "SO_Data Import Specification", "SO_Data", "C:\Documents and Settings\DowlinMM\My Documents\Development\SciQuest_SupplyMgr\UH Mgt Inventory Rptg\Sciquest Data\SO_Data.csv", True
  2.  
May 3 '11 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.