import a tab delimited text file into access using ado

D

Dagny Taggart

How would I get a tab delimited text file into access? I am stuck and can't
get up. I think I've gotten to a point where I've read and looked at so much
I don't know where to start. If anyone can start me out, I think I can
figure the rest out.

Thanks-in-advance
 
K

KeithG

I have used the TransferText action in a macro to import delimited text into
access and then an append query to add the imported records into the tables.
Hope this helps.
 

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

Word 2016 - Difficulties Learning Style Creation/Application 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
transfertext delimited 1
Converting Pipe Delimited Text File To Tab Delimited Text file 3
Move Chart with Text 0
How to use first row of delimited file for field names when importing ? 1
Import Text file with Pipe Delimited - 2007 4
flashcard file with bad page 0

Top