need macro for import text file with delimiter

  • Thread starter Thread starter yuvalbra
  • Start date Start date
Y

yuvalbra

I used access 2000 , i have a table that containe the fields for the
text file

need macro for read the file ,import it,and after all delete the file

can anyone help me?
 
You need to manually import the file the first time and save the import
settings. Then use TransferText to import the file specifying those
settings.
 
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
Macro to Import TXT file and format the file 3
Macro Conditions 1
Transfer Text, Export Delimited w/ Number formated to 4 decimals. 1
Best Tool to Repair Corrupted PDF Files 0
Bulk Import DBF files to access 2003 1
Export from MS Access 2007 to Quickbooks IIF - How can I create a tabdelimited text file from Access 2
Office 2007 TransferSpreadsheet Import 5

Back
Top