Trouble Importing text file into Access 2007

T

TeddieMao

I am trying to import a large text file (over 170k rows) into Access 2007.
This is something I do each month and I haven't had any problems. But now
when I try to import the file, I cannot import the dates. The fields are
empty. Some background. There are over 170k records and 49 fields. When I
import the file the delimiter is |. I have a format all set up in the
Advanced tab of the Import Wizard but this doesn't seem to do anything when I
put the date/time property.
 
S

S.Clark

I prefer to import data into existing tables, such that the data types are
already set.
 

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

Top