How to automate import from a text file into access table - URGENT

  • Thread starter Thread starter ljubo lecic via AccessMonster.com
  • Start date Start date
L

ljubo lecic via AccessMonster.com

How can I automate import from a text file to an ACCESS
table. Could it be written as a macro that is called on
opening the form.I am new in ACCESS and I need macro code.
Thanks in advance.
 
ljubo lecic via AccessMonster.com said:
How can I automate import from a text file to an ACCESS
table. Could it be written as a macro that is called on
opening the form.I am new in ACCESS and I need macro code.
Thanks in advance.
Click to expand...

You want the TransferText method/action, look it up in help. There's
probably a VBA example. I wouldn't know about macros, I never touch them.
 
You must log in or register to reply here.

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 Text Files Into Access 1
How to export table from outlook into ms access table? 0
Importing any excel files with any sheet name into different tables in MSAccess using code 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Table Default Values 1
How to Create a Macro to Import External Data 0
PLEASE HELP: automate process to import tables from notepad to acc 9
Import files into access 1

Back
Top