ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Updating Access table with a range from Excel, (https://www.excelbanter.com/excel-programming/376246-updating-access-table-range-excel.html)

ado

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


All times are GMT +1. The time now is 03:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com