View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Przemek[_2_] Przemek[_2_] is offline
external usenet poster
 
Posts: 9
Default [Excel2007] How to obtain provider name for ADODB.Connection

Hi!.

I'm trying to connect to .dbf files via adodb service.
The problem is that i dont know how to obtain correct provider name for the
chosen ODBC driver.

On msdn website i've found that its enough to choose standard
Microsoft.Jet.OLEDB.4.0,
but it doesn work with VFP .dbf files (unrecognized database file format ).

I have several odbc drivers innstalled and i could work with any of them,
but i cant find the way
to know its provider name.