View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Poppe Poppe is offline
external usenet poster
 
Posts: 16
Default Excel connection to ODBC database

Hi

I have excel 2007 .xlsx file. It contains exactly same rows as my database.

How can i create an automated connection, that updates the data to a
database via ODBC?

For example:

I update a row in excel file - The updated value goes automatically into
the database.

Thanks for your help!