General information
Category:
Database DAO/RDO/ODBC/ADO
Title:
Accessing foxpro table
Can anyone show me how to access a foxpro table using ADO?
I have the following code:
Dim sWorkspace As Workspace
Dim sDatabase As Database
Dim sTable As Recordset
Set sWorkspace = DBEngine.Workspaces(0)
Set sTable = sWorkspace.OpenDatabase("c:\cmts2\cycle14\arpbal2.dbf")
Set sAction = sTable.OpenRecordset("Select * from arpbal2")
But I get an error message at the second Set statement that goes:
Run-time error '3343':
Unrecognized database format 'c:\cmts2\cycle14\arpbal2.dbf'.
Would appreciate any help. Thanks.
Ramon
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only