Read Progress DB using Excel VBA 1

[dsi]

We are using a Syteline ERP system which uses a Progress DB. We have a tool to query the DB, but is really lacks in functionality. I would like to write an Excel VBA program to extract data from the DB. From there I will manipulate the records and generate reports. I am quite familiar with Excel, VBA and VB, but am lacking in the experience required to access the DB. I am familiar with the tables and fields, so I just need some help getting connected.

I have spent much time searching the internet for samples, but have no which direction to go. I am not at all familiar with DAO, ADO or ODBC. Could someone recommend a method to use for this Read-Only database project?

Secondly, does anyone have a sample of how to connect to the Progress 9.1C DB? Most of the sites I have looked at never even mention Progress, so any pointers you have would be greatly appreciated.

Thanks!

 

[ETID]

If you have an ODBC driver installed for you database, then making a link to your db is a quit simple. ...(and no code write)


Let me know if a driver is available or installed on your machine.

 

[ETID]

The Progress SQL-92 ODBC (Open Database Connectivity) Driver is supplied by MERANT
Inc., formerly known as Intersolv. In this manual, the driver will be referred to generically as
the Progress SQL-92 ODBC driver. It runs on Windows, Window NT, and UNIX
environments. It is installed when you install the Progress SQL-92 Client Access product.
This chapter provides a brief overview of the ODBC interface, and describes how the Progress
SQL-92 ODBC driver provides access from a wealth of desktop tools to the Progress database.

manual available at.........

http://www.progress.com/v9/documentation/sql92/odr/odr.pdf

 

[dsi]

Thanks, I will check it out. I've been programming for some time, but this is new territory for me.

 

[ETID]

I'll be glad to coach if I can

 

[dsi]

Hey, since you still have this thread marked, I just may take you up on your offer. I'll hack at it for a while before I cry for help.

Thanks again!

 

[dsi]

Well, I'm back and clueless. Do you have any pointers to sample code (VB) that would use this DSN connection? Do you know of any tutorial type sites that cover this?

Thank you.

 

[ETID]

do you have the driver installed?

 

[dsi]

Yes, the driver is installed. There are two MERANT DSNs already established. The problem I am having with creating a new DSN for my app is with the port. I am not sure which port to use. I am trying to get with our admin to get the info, but this is all relatively new to us. One of the existing connections is used for the same DB, but for a different application. I was hoping to be able to tap into that one to get started on learning the coding.

 

[ETID]

can you do a manual/step by step link....

I.E.

in excel , goto data>get external data>new database query,...

at this point does your driver / dsn appear in the databases tab.?

 

[dsi]

Yup!

 

[ETID]

If you are succesfull at returning data to an excel Spreadsheet, then turn on the macro recorder and repeat, recording the steps. then you'll be able to edit to code and see the syntax for the DSN

 

[dsi]

Duh! I can't tell you how many times I have told others to record a macro first.

If I could, I'd give you another star. Thanks!!!