can i link a excel table

B

bubtrauma

I would like to export my access table to excel, and that I have done.

Now how can I link it so the changes that I make in access also changes the
table in excel.
 
G

George King

You can't link the Access table to make updates appear in Excel, but:
You can make the Excel worksheet THE database.
In Access, File > Get External Date > Link Tables,
Navigate to where the Excel worksheet is, Select the worksheet, Click Link.

The field names must be in row 1 in Excel.

This will make the Excel table the table that Access uses, therefore,
changes made in Access will show up in Excel.
 
Top