Hi
I need some help on how to do the following.
I have a table in acces with 13 columns + Id column with auto number.
I have a excel form that I fill in evry day, with info of items that have to left our company. it have only 7 column on it.
How can I append the info form the excel sheet into table in access only using the 7 columns that is on the excel sheet.
At the momnet I have to add all of them by hand, and somedays there are a lot of them, just want to make it easy for the user.
The name of the excel form change every day as I have to save.
Is there a sample on how to do it.