Access 2003 can't import delimited files

P

Pic

I'm using Access 2003 on Win XP SP2.

Trying to import an Excel CSV file using "get external data", but
neither csv or ANY delimited formats are offered as an option in the
Import dialogue box.

I tried using the "Text" option but it did not regognize my columns as
fields.

Any ideas about how I can fix this?

Thanks in advance,
Pic
 
K

Ken Snell \(MVP\)

In my ACCESS 2003 (Win XP PRO SP2), I see this option in the dropdown list
for file types:

Text Files (*.txt, *.csv, *.tab, *.asc)

You don't see this option?
 

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