Updating Access table with a range from Excel,
Hello,
I have an application on Access which create and export a query from Access
to Excel using a xls template that i defined. I would like to update from the
Excel sheet to the Access table. If i go to Access and try to link the Excel
sheet i have a range name, what i mean by that, is that i have a table in
Excel with headers on which i want to create a sql query to update the
records in my Access table.
Thanks in advance
|