Import data from "; delimited txt file"

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

 

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

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