Importing Data Automatically

[Guest_imported]

Hello,
I need to find a way to automatically import an ASCII file into an Access table. I know how to do this manually, but was not sure how to script such a complicated process.

Thanks

 

[gwinn7]

In the past few days, there was a thread specifically related to this topic.

Gary
gwinn7

 

[braindead2]

check out transfertext under access help. You can use it either as an Action(macro) or in VBA. Is quite simple to code.
Good luck

 

[EPBoone]

I have been trying to use the TransferSpreadsheet in a macro, but it won't do it. I keep getting an error message saying "System Resource Needed." Any idea what that means? I also tried to use the TransferText method, but it keeps telling me I don't have permissions to read the " file. Can someone give me some advice here. This is driving me up the wall!! Thanks...