Hi Sherman thank you for comment!
But I still can not define where the table is under "Table Name". Because I am trying to run the Macro or Code from my Front office database and importing the file to the Back office database.
I am trying to avoid importing and exporting files in a...
Importing text files using code (Docmd.transfertext using import specification). We are using Access 97.
We want to be able to run code in database (A) to import the text file into database (B)?
Does any one know how we can do this?
Erthman
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.