Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,226
- Office Version
- 365
- Platform
- Windows
I have a text file which I am importing into Access. The date fields on this file are formatted "mmddyy", so today's date would look like 091306.
In the past, I have always imported the field as a Text field, and used a query to convert the value to a Date field. Is there any way to import the value directly as a date, so I don't need to use a query to convert it?
I don't mind setting up and using Import Specifications, if that helps, or importing into an established table, but want to avoid using a complex VBA routine to do it (I am looking to make this simpler, and using VBA in this case wouldn't be simpler than my query workaround).
Thanks.
In the past, I have always imported the field as a Text field, and used a query to convert the value to a Date field. Is there any way to import the value directly as a date, so I don't need to use a query to convert it?
I don't mind setting up and using Import Specifications, if that helps, or importing into an established table, but want to avoid using a complex VBA routine to do it (I am looking to make this simpler, and using VBA in this case wouldn't be simpler than my query workaround).
Thanks.