Automatically get Excel data

[TimG]

Hi,

I have a worksheet with projects in Excel that I want to load in an Access database. I only want to import 3 columns though.


I managed to do this by using the get external data function (import) from Access. I get all the data nicely in a table. However, how can I make it so it refreshes the data when the DB opens? So if there are new records in the Excel worksheet, it will automatically put them in the table.

I tried using the link function from 'get external data' too, but it looks like I can't add any colums to the created table.

Any advise on this?

Thx in advance.

[dcrake]

You can link the worksheet as you have mentioned but then you can have another table in Access that use can use a query to effectively join them together using the Primary key as an inner join.

David

[TimG]

Hey, thanks for your answer. This did the trick. I figured out I had to use an outer join to see all my rows though. Thx a bunch