Import data from "; delimited txt file"

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?
 
S

Stefan Hoffmann

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 <--
 
Top