In Access, "File/Get External Data/Link Tables"
Choose Microsoft Excel(*.xls") in the "Files of Type" box
Locate your workbook and place it in the "FileName" box.

The next dialog box will allow you to select the sheet and range to which to
link. Choose the table with the same headers and you should be set.
--
Best wishes,

Jim


"Ado" wrote:

Hello everybody and thanks in advance.
I have an Excel file with a range defined with a name (test_range), the
first line like a header. And i have an Access db with a table contains the
same header of the range from the Excel file.
I would like, in excel, to update the table in Access with the range
(test_range) from Excel.
Can someone help ??