Automating excel import to Access

[ColonelSanders]

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]

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