Automate Import

[mathisjay]

I have a situation where I need to be able to import a .csv file every quarter.

I know how to import the file into a table manually using the "Get External Data..." method, but I would like to be able to automate the process from the click of a button. It can be assumed the file will be located in the same place and named the same thing every time.

Is it possible to do this? How do I do this from VB code?

 

[halewilson]

Pat,

When I tried your method I kept getting an error dialog "The source database has no import/export specifications to copy." It didn't work out exactly the way you described but it did point me in the right direction. I was able to create a TransferDatabase macro then convert it to VBA and modify the file path's...working nicely!

Mahalo