Text File into Access not bringing in Dates

  • Thread starter Thread starter TeddieMao
  • Start date Start date
T

TeddieMao

I am trying to import a text file (large one) with multiple dates as a
delimited file but when Access imports the date do not show up in the table
 
in the step through wizard the fourth step allows you to identify each fields
datatype (2003) On that page is an 'Advanced' button. Once there you can
identify the field as a date.
 

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

Importing Text Files Into Access 1
Trouble Importing text file into Access 2007 1
Error while import Excel file to Access 6
Import text file data conversion problem in Access07 2
Access 2007: Import Text Wizard errors 4
Access Importing csv daily files into access 2007 1
Format General date format into short date when exporting 1
How to export table from outlook into ms access table? 0

Back
Top