how can I write a macro to import a txt file into a mdb file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been trying to write a macro to import a txt file into an Mdb file.
For some reasons it just does not work. My plan is to have a file, macro.mdb
that when I open it has a macro that opens a txt file, test.txt and exports
it into an mdb file.

Thank you for your answers and help
 
Hi,
do you get some error?
Your plan looks ok, to import text file you can use TrasferText action
 

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

Importing .txt file into Access Table - Want Prompt 1
VBA code importe txt file 2
reference application object of mdb opened with OpenDatabase 16
Access MS Access Office 2010 1
How to Create a Macro to Import External Data 0
export all modules to txt files 1
Access 2003 and/or 2007 copy in objects from another mdb 1
How to Monitor a folder and write log to a .txt file? 5

Back
Top