Updating from Excel sheet

[Jimbo]

I have an Access database which contains member information for a Golf
Association.

I would like to capture activity - that is - when the last time someone
played in a tournament and how many tournaments this year

The golf shop can give me an Excel spreadsheet with a list of all who play
in each tournament, and some other info.

What would be the best way to automate the process ? I have already added
fields for the new data.

Thanks in advance for ANY help

JM

 

[Smartin]

I have an Access database which contains member information for a Golf
Association.

I would like to capture activity - that is - when the last time someone
played in a tournament and how many tournaments this year

The golf shop can give me an Excel spreadsheet with a list of all who play
in each tournament, and some other info.

What would be the best way to automate the process ? I have already added
fields for the new data.

Thanks in advance for ANY help

JM

You do have the ability to link to the spreadsheet and treat it as
though it were a table. You can then possibly query, update, and add
records just like downtown. How feasible this is depends rather a lot on
how the excel data is structured though, and of course, your own data
design.

 

[Jimbo]

Thanks - I will look into it - seems like if I can link to it, I should be
able to pull it off

JM