AncientTiger
Programmer
I'm setting up a VBA app using Excel, and I need to be able to connect to and manipulate data in a Lotus Approach database. I'm vaguely familiar with how to do this with Access, but I can't seem to get it done with Approach.
Can ANYONE show me how to set up the connection string for this? I know with access it's:
dbsource = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:\mydatabases\thedatabasefile.mdb'"
Set cnn = CreateObject("ADODB.RECORDSET"
cnn.open "SELECT * FROM myTable" , dbsource
...
...
But this doesn't work when I substitute "thedatabasefile.mdb" with "myapproachDBfile.dbf"
ANY help would be MUCH, MUCH appreciated (code examples MORE than welcome
AT
Can ANYONE show me how to set up the connection string for this? I know with access it's:
dbsource = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:\mydatabases\thedatabasefile.mdb'"
Set cnn = CreateObject("ADODB.RECORDSET"
cnn.open "SELECT * FROM myTable" , dbsource
...
...
But this doesn't work when I substitute "thedatabasefile.mdb" with "myapproachDBfile.dbf"
ANY help would be MUCH, MUCH appreciated (code examples MORE than welcome
AT
