Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connecting to Lotus approach with VBA/SQL

Status
Not open for further replies.

AncientTiger

Programmer
Jul 5, 2001
238
US
Here's a good question for y'all...
Let's say that I've got a Lotus approach database file on my pc, and I want to access data using Microsoft excel's VBA with SQL. I know just enought about SQL to manipulate data in an Access DB, but can it be done with Approach as well? Is SQL really a STANDARDIZED Query Language?

Also, if it CAN be done, what would the connection string look like? I know that with Access it's:
-----------------------------------------------------
dbsource = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:\somefilepath\mydatabase.mdb'"
-----------------------------------------------------

but with Approach what would it be?

dbsource = "???????????????????????????????;Data Source='c:\somefilepath\mydatabase.apr'"



Thanks for any help!
AT
 
You could probably connect to the individual dBase database files using SQL and ODBC, but there is no way to connect to the APR file. The APR file does not contain any data - that is where the forms, reports, etc are stored.

Sue Sloan
 
Ok, I hear you there.... now as far as the connection string...

Since it's not going to hit a .mdb file, could I still use the
----------------------
dbsource = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:\somefilepath\mydatabase.dbf'"
----------------------
connection string, or would it have to be different. I believe the extension on the file you're talking about is .dbf, correct? What provider would handle that sort of connection, and what would the connection string look like?


Thanks a TON!
AT
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top