var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Importing a date/time field in Access table
I have created an access table with three fields.
InstanceName - Text
Date - Date/Time
Description - Text. (Set to Custom format - yyyymmdd hh:nn)
Iam trying to import the data from a text file which looks like this
When i try to import this file the second field is not getting imported due to Type conversion error.
Any help is appreciated,
I think what you are going to have to do is to do the import in two steps.
1. Link the the file, make sure when you link to the date field you make it a text field
2. Then create a query that uses the Left and Mid functions to put the text date into a date format Access recognizes. An make it append to the table you want or create a Make Table query.
CDate(Mid([x],5,2) & "/" & Mid([x],7,2) & "/" & Left([x],4) & Mid([x],9,999))
Yup. Or use code to import the data.
Owner and Manager of
CypherBYTE, Microsoft Access Development Specialists.
Microsoft Access MCP.
And all around nice guy!
"Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "