Importing comma delimited text files

A

amber

I'm looking for some information on importing comma
delimited text files into Access.
I have no problem doing it with the Import wizard, but I
want to do it through VBA.
I read through the postings in this newsgroup, and read
the help in Access, but it is all so specific.
I'm looking for a basic overview/explanation.
If someone could point me in the right direction, I would
be very grateful!
Thanks!
amber
 
N

Nikos Yannacopoulos

Amber,

Start by doing a manual import, so you create and save an import
specification. Following that, DoCmd.TransferText will do it in VBA; see VB
help on the syntax, it's quite straightforward.

HTH,
Nikos
 
R

Roger Carlson

One way to get started is to create a Macro that does the import. Then
convert the macro to VB Code (you can do that with the SaveAs option).

Also, on my website are a number of sample databases devoted to importing
various types of text files: delimited, fixed, html files, etc. Mostly they
start with "Update" or "Import". You can find them here:
www.rogersaccesslibrary.com
 

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