ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using qry from excel to update tables in a db2 database (https://www.excelbanter.com/excel-programming/291139-re-using-qry-excel-update-tables-db2-database.html)

DB2

Using qry from excel to update tables in a db2 database
 
Hi,

You need an ODBC driver for DB2, ie StarSQL (www.starquest.com)

Good luck!

Bob

sod wrote in message ...
Update tables in DB2 using input from Excel using msqry ( linked tables )

This is an working option in access. Can this be done from excel using msqry ? The odbc driver must of course be set with edit function.

I'd appriciate very much if someone out there could help me with this issue.



All times are GMT +1. The time now is 11:07 AM.

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