Using Excel to update Access Database

[Swade730]

Hi,



I'm hoping to get guidance on where I can find resources on using an Excel workbook to Update an Access Database.

Let's say for example the database manages basketball player stats...
and
I want to use an excel workbook to enter the info/stats such as points, rebounds, steals etc..., to click a button and have that info appear now in access.

But when the Database updates, I want understand how to have it so that...

1. any info I enter overrides any previous data for that player
-as well as -
2. add a new line of data for the player (keeping the previous data)

[ranman256]

you can do it either way, 1 or 2.
I have a generic import xl file, Import.xls.
I save my latest data to over write this import workbook.
The Import.xls file is linked as a table inside access.
so then I just run a macro.

1. overwrite the import.xls
2. run import macro.
done.

The import macro can have queries to either add to exising, or overwrite data in the tables.
your choice.

[Swade730]

you can do it either way, 1 or 2.
I have a generic import xl file, Import.xls.
I save my latest data to over write this import workbook.
The Import.xls file is linked as a table inside access.
so then I just run a macro.

1. overwrite the import.xls
2. run import macro.
done.

The import macro can have queries to either add to exising, or overwrite data in the tables.
your choice.

Do you have the example you share or attach here?

[alansidman]

Alternatively, if your data is normalized in your excel file, you can link your Excel table/file to Access and it will act as if it were a table within Access. It is updated in Access as it is updated in Excel.

[alansidman]

crosspost at: http://www.excelforum.com/access-tab...onditions.html