Forum Moderators: open

Message Too Old, No Replies

Access database

         

blzalewski

1:55 pm on Jun 14, 2007 (gmt 0)

10+ Year Member



How would I get an Access database to automatically import/add relationships to any excel files I put in a certain folder?

Any input would be appreciated, thanks.

shigamoto

7:36 am on Jun 15, 2007 (gmt 0)

10+ Year Member



There is no problem to manually import data, obviously. Doing it automatically would probably require you to write some code in VB, something that tells it to check a folder for .xls files automatically at a certain time each day or week.

It pays to look around the net, maybe someone already wrote such a script. You can also write a more simple script using with a browse button, but then again you would do it manually.