Office geekery.

Killavodka · Post by **Killavodka** » January 14th, 2007, 16:34

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

amblin · Post by **amblin** » January 14th, 2007, 17:31

Killavodka · Post by **Killavodka** » January 14th, 2007, 17:33

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.

Hehulk · Post by **Hehulk** » January 14th, 2007, 18:11

Whiskers actually

Post by **FatherJack** » January 14th, 2007, 21:24

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

Code: Select all

dir /b *.xls > files.txt

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.

Killavodka · Post by **Killavodka** » January 15th, 2007, 1:55

pfft at fatherjack for sticking to the topic

5punk

Office geekery.

Office geekery.

Re: Office geekery.