Importing a .txt file using a macro

[pkondilys]

Hello,
Don't know if this is possible:
I have a an access database, & I would like to create a macro that imports a specific .txt file on an automated time schedule. The .txt file that is being imported gets overwritten everyday, and so I would like to create a macro that would import the data of the .txt file to a table. is this possible?

Thanks in advance guys...

 

[grnzbra]

There is a TransferText macro that should be usable. The TransferText command in VBA would do what you want, so I would assume that it would work the same in a macro.

Don't know if you could directly use a macro on an automated schedule, but if you opened a form, you could use the timer event to check what time it is every 10 minutes or so and if it matches the scheduled time, run the macro.