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

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
 
A

Alex Dybenko

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
Access MS Access Office 2010 1
Import file error 1
How to Monitor a folder and write log to a .txt file? 5
Auto Open Macro of external .txt file based on cell reference 1
Convert mdb file to txt file 4
Help, how do I import a CSV file when Negatives are in Parenthesis 3

Top