How do I import a delimited text file into Access?

G

Guest

I receive a daily text file (coma delimited) and I would like to be able
"open" it with access. What are the steps I should follow?
Thanks for your help
 
G

G. Vaught

Open Access
Select File | Get External Data
Import
Select the txt file
You should get prompted with a walk-through wizard.

If you have problems with the text file, it may warrant a slight clean-up to
import properly.
 

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

Import Text file with Pipe Delimited - 2007 4
The text file specification '4' does not exist 0
Import Text Semi-Colon Delimited - Macro Issue 2
How can I import non-delimited text file into access 3
Importing Text Files Into Access 1
Tabbed Delimited Text recognizing headers? 2
Text on Multiple Rows of Text File 1
Tab-delimited *.txt file linking; text into numbers 1

Top