Importing comma delimited text files

  • Thread starter Thread starter amber
  • Start date Start date
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
 
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
 
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
 
Back
Top