How to automatically import Data

[CTOROCK]

How can I append data from a txt file to one of my tables?
I have a script which exports a txt data table in txt format at a certain time through windows tasks. how can I schedule Access to automatically import the data at a certain time? And how do I append the data to a specific table instead of creating a new one or overwriting one?
Thanks in advance
Eric "The greatest risk, is not taking one."

 

[tlbroadbent]

Use the TransferText Action in a Macro or the TransferText Method in a module. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.