Automate append of text file to mdb table

G

Guest

I have a text file that I want to append (on a regular basis) to a history
table using Access 2000 or 2003. I am currently doing this manually (by
using "Get External Data", Import, etc.) with an Import Spec and it works
fine. How can I automate this--like setup a button for a user to push that
would perform this function (I need to use the import spec). Should I use a
macro, shd I use an
append query, or should it be done in VBA (maybe behind a button)?
Thanks for any suggestions.
 
G

Guest

You could use either a macro or VBA. If you create a macro that uses the
TransferText, the first box is the name of the import spec. Then have your
button run the macro. If you want to use VBA, then write use the
TransferText method of the DoCmd object. The second argument for
TransferText is the spec file name.
 

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

Append Geocode Data from Text File (via Query) Not Working 3
Can I automate the import of a text file? 2
Append csv or xls file to existing table 3
Recurring import of linked text file data 10
Error Importing Fixed-Width Text File 1
Importing text file using spec into existing table..same as append 2
Best way to import text file into existing table on a daily basis 15
Import Multiple Text files in Folder 3

Top