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!

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!

Hi

Your answer creates an ODBC connection into the excel file.

I do not want this.

I have already the ODBC connection created under administrative tools to my
database that is located in a server (sybase sql).

I need to create connection from the excel file into this database via ODBC,
so that the updates to excel file go automaticallly into the database table.

BR,
Poppe


"Jacob Skaria" wrote:

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!

That would be database connection TO Excel, not from.

Poppe wrote:

Hi

Your answer creates an ODBC connection into the excel file.

I do not want this.

I have already the ODBC connection created under administrative tools to my
database that is located in a server (sybase sql).

I need to create connection from the excel file into this database via ODBC,
so that the updates to excel file go automaticallly into the database table.

BR,
Poppe


"Jacob Skaria" wrote:


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!

Hi

The data needs to move from an excel chart to the database.

Can anybody help ? For example with VB script ?

Thanks!

"Bob I" wrote:

That would be database connection TO Excel, not from.

Excel doesn't SEND data. Consider asking the folks in the group for your
database, as you want "pull" the Excel information, working from the
database end.

Poppe wrote:

Hi

The data needs to move from an excel chart to the database.

Can anybody help ? For example with VB script ?

Thanks!

"Bob I" wrote:


That would be database connection TO Excel, not from.