View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Excel connection to ODBC database

http://www.datamystic.com/datapipe/excel_odbc.html

If this post helps click Yes
---------------
Jacob Skaria


"Poppe" wrote:

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!