Access database

[blzalewski]

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]

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.