>Does the new VFPOleDB provider work with any of the MS Office 2000 products (i.e., Excel, Word, Access, etc.)?
In theory you should be able to do it.
>Is it possible to setup a DSN to the VFPOleDB provider? I can't find it listed in the ODBC driver dialog on a Win 2000 workstation.
OLE-DB providers are not listed on the ODBC driver dialog. They are handled separated.
This is the code that I used in an ASP file to connect to VFP data through the OLE-DB provider. You can probably adapt it to VBA failry easily:
'Connect to our database.
set oConnection = Server.CreateObject( "adodb.connection" )
oConnection.Provider = "vfpoledb.1"
oConnection.ConnectionString = "data source=c:\testdata\tastrade.dbc"
oConnection.Open
'Get our recordset
set oRecordSet = Server.CreateObject( "adodb.recordset" )
oRecordSet.Open "select * from customer", oConnection, adOpenStatic
Hector Correa