Transfer data from excel to ms access database

[Hudas]

Hi!

Everyday I have to generate a report in excel format and I need it to be added to ms access database. I was hoping to do this on a click of a button. Basically, since i have a new data everyday it should be added to the table. Can anyone please point me out the the right direction or maybe a sample code.

Thank you!
Hudas

 

[Rx_]

Search the Code Repository and Sample Databases on this Forum:
http://www.access-programmers.co.uk/forums/showthread.php?t=249041

Here is a long winded example for customizing the process and the short built-in version:
http://www.access-programmers.co.uk/forums/showthread.php?t=248093

Typically, attach the Excel data, bring it into a table, process the table data, delete the table for the next time.