Automating Import Files

[henley12]

I have a database which gets updated every month via an Excel CSV file. Is there a way to automate the import process so that I can press a button and it will allow me to browse for the filename to select for import? I have an import specification created and the data is going to the same table every time.

 

[stix4t2]

the application object allows for a file dialog. Search this site for code to implement this. Then using the filename use the docmd.transferspreasheet command to import the data from the file.

 

[mp9]

Search Access VBA help for the FileDialog object.

http://www22.brinkster.com/accessory/

 

[addy]

See PHV's response in this thread:

http://www.tek-tips.com/viewthread.cfm?qid=938499