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!

Register Log in
  • 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

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
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Harami12
  • Locked
  • Question
Where to Next in Programming 2
Replies
2
Views
186
Andrzejek
Andrzejek
LuciusThorne
  • Locked
  • Question
Database Design - Reusing one-to-many relationship in a table?
Replies
4
Views
170
mintjulep
M
RasaBu
  • Locked
  • Question
Hello, I need to create a FoxPro
Replies
1
Views
131
Mike Lewis
Mike Lewis
dwf1962
  • Locked
  • Question
Trying to write a simple Foxpro prog to convert database of probabilities to a life expectancy table
Replies
1
Views
167
SkipVought
S
TopTeller
  • Locked
  • Question
Is ms-access a true recommendation for students to use with VB? 2
Replies
4
Views
128
SamBones
SamBones

Part and Inventory Search

Sponsor

Back
Top