Connect to MaxDB database using MS Excel 2003/2007

[Former Member]

Hi All,

TO retrieve data from my MaxDB database, I would like to connect to MaxDB database through Excel. Does anyone have a idea how to connect and retrieve? I am using VBA programming generate few things.

Help greatly appreciated.

Thanks and Rgds,

Pradeep

[Former Member]

Pradeep,

Can you pl. Post the approch and steps you took inorder to acheive the retrieve data into excel

[Former Member]

With cnLTC

.ConnectionString = "DRIVER=MaxDB;" _

& "SERVER=" & sServername & ";" _

& "DATABASE=LTC_DB;" _

& "UID=ADMIN;" _

& "PWD=ADMIN;"

.CursorLocation = adUseClient

.Open

End with

Won't it work?, i guess it would!

[lbreddemann]

Hi Pradeep,

how about using ODBC?

Excel even provides a frontend (menu DATA -> import external Data) to access data in e.g. ODBC databases.

best regards,

Lars

[Former Member]

Perfect.. that really helped me 75%!!

One more help..

If i have two tables and one field from a table is a referential key to another table. How can we import proper data during import in Excel? COz when i tried to retrieve System ID then in the table entry we have 6 which references to ABC for example. When i import it collects 6 but not ABC.

Thanks and Rgds,

Pradeep

[lbreddemann]

Man .. from your "expert areas" (...Programming,ORACLE,MSSQL...) I would have assumed that you won't have problems with that...

You've two tables and you want get out connected data from it?

Use the force and the power of the mighty JOIN...

I don't know if you're writing SQL yourself or just using the 'import a table' functionality.

In the later case it might be a good idea to create a view for the join.

regards,

Lars