Automating excel import to Access

ColonelSanders · May 18, 1999

I need to be able to take data out of an Excel spreadsheet that is updated daily and export it to an existing Access database. I need the info to be added as a new record everyday so I am looking for a way to automate this procedure. Any suggestions would be greatly appreciated. <br>
Thanks, Randall

KimiSue · May 24, 1999

I would suggest that you go to the Access program, select the Macros tab, and select TransferSpreadsheet. Look at the help section on this function and see if it helps. I've never used this before, but it seems to be exactly what you're looking for!<br>
Good Luck!<br>
kimi

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Automating excel import to Access

ColonelSanders

MIS

KimiSue

Programmer

Similar threads

Part and Inventory Search

Sponsor