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.