Import data from "; delimited txt file"

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

I need to import several txt files(; delimited) into tables on a daily basis.
from these tables I require only parts of the inforamtion in the tables.
What is the best procedure for this?
 
hi Richard,
I need to import several txt files(; delimited) into tables on a daily basis.
from these tables I require only parts of the inforamtion in the tables.
What is the best procedure for this?
Click to expand...
Import the entire file into an import table using an import
specification. Use an append query get your data in your normal tables.

http://www.databasedev.co.uk/text-import-macro.html


mfG
--> stefan <--
 
Back
Top