re:
Hi,
you would need to use the TransferText method to import the file. After that it all depends on what you are trying to do. If you need to specify an import specification to import things correctly then import the file manually once and use the advanced button in the import wizard to create, name and save the specification...then reference it in the specification argument of the TransferText method. Furthermore, do you want this to manually execute or automatically? If automatically then there are two methods...if the application is open 24/7 then you could use a form's on timer event to check the current system time/date and execute the function based on that. If it will be closed then use a macro which executes your code...then call this macro with the macro command line switch in a batch file. You can schedule this batch file with the windows scheduler or any other scheduling software for a specific date/time.
Last but not least...keep in mind that it is almost always better to first import everything into a blank new database...then use append queries to append the data correctly formatted to existing tables. You can always drop the temp tables programmatically later on if needed.
HTH
Good luck
