View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ado ado is offline
external usenet poster
 
Posts: 5
Default 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