5punk

.

ummm.... i knew i should have listened to the teachers at college, instead of playing cs 1.6 on the college computers

.

they gave it back when i cancelled my account... Eve probably steals your brain, turns it into pedigree chum then feeds it to the local poodle population.

Whiskers actually

amblin wrote:I know how much everyone here knows and loves MS office so I have a question.

How can I get output from multiple excel sheets into one access database regularly and automatically?

If you use 'link table' rather than import to grab the speadsheets the tables in access will stay in sync with the XLS files.

If there are new tables to import each day, and you want that to happen automatically, record a macro of yourself linking one, then edit the code to grab the new tables, assuming they have a name based off the date or an incremented number.

To scan for any files in a dir, run a batch file with in it, link the files.txt to a table in access and uses that combined with the code to link in the new tables. Again, recording yourself doing a macro is the easiest way to get started, I'm assuming you're not into writing Access VBA from stratch, as it could all be done that way.

pfft at fatherjack for sticking to the topic