Is there a Macro

  • Thread starter Cipher via AccessMonster.com
  • Start date
C

Cipher via AccessMonster.com

I need to load an external text file into a Table so the user can edit it in
a Form. There are several text files that need to be loaded. It was suggested
that I automate this function and I need to know if there is a MACRO vailable
for Importing External Text Files into a Table and Exporting the results of
editing the Table using a Form so that the Table re-writes the Table Data
back into the External Text File.

If I need to do all this in VBA, please assist me in the name of the
Functions so I can look up the syntax...thanks
 
D

Douglas J. Steele

As I said in my post, you'd use TransferText. It's both an action (for use
in macros) and a method (for use in VBA), and it works both for importing
text files into Access and exporting Access tables to text files.
 
C

Cipher via AccessMonster.com

I now have eleven books on Access and not one of them mentions "TransferText".
Is there a book or Website that has up-to-date Programmers Reference to these
Functions/Macros/Other? I thought that the Access 2007 VBA Programmers
Reference would be good, but it is quite useless...thanks for the tip.
As I said in my post, you'd use TransferText. It's both an action (for use
in macros) and a method (for use in VBA), and it works both for importing
text files into Access and exporting Access tables to text files.
I need to load an external text file into a Table so the user can edit it
in
Click to expand...
[quoted text clipped - 9 lines]
If I need to do all this in VBA, please assist me in the name of the
Functions so I can look up the syntax...thanks
Click to expand...
Click to expand...
 
Top