text cvs to date format

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

Posting the same question every half hour is not a good way to make friends
here or on any forum.
 
S

Stacey

Forum - please disregard this question. Thanks!

Pat Hartman said:
Posting the same question every half hour is not a good way to make friends
here or on any forum.
Click to expand...
 

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

CSV text into Date field 1
CSV text to Date Format 2
CSV text into date format 2
CSV Text to date import 6
Change text to date in reverse order 3
Export From Access 2003 to CVS file format 3
exporting results of a query or table in cvs format 3
Text to date conversion 5

Top