CSV text into Date field

S

Stacey

I have a file which I will be uploading into Access on a regular basis. The
date field is formatted to text which I would like to format into a date
field upon importing into Access. I would also like to rearrange the date
into a regular format, it reads as such 082101 and I would like it to read
01/21/08. Any help is greatly appreciated. Thanks in advance!

Stacey.
 
P

Pat Hartman

Do the import again ONCE manually and create an Import Spec and save it.
This will allow you to specify the format of the input date so that Access
knows how to convert it to a DateTime data type. You would then refer to
this import spec in your code in the TransferText method code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

text cvs to date format 3
CSV text into date format 2
CSV text to Date Format 2
CSV Text to date import 6
Change text to date in reverse order 3
Importing Date field into Ms Access 10
Text to date conversion 5
Convert a Text field to Date/Time 1

Top