JET OLE DB 4.0

OLE_Newbie · Joined: 04 Oct 2007 Posts: 1

Where can I obtain a good Programmer's Reference Guide for JET OLE DB 4.0.
That is the one that comes with Excel. I am fairly profiicient with writing
macros in Visual Basic. I need to know the functions and syntax of statments
such as:

'Open an ADO connection to the folder specified
Set oConn = CreateObject("ADODB.CONNECTION")
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strFilePath & ";" & _
"Extended Properties=""text;HDR=Yes;FMT=Delimited"""

Thanks

Archived from group: microsoft>public>vb>ole

SueLittle · Joined: 04 Oct 2007 Posts: 1

I am reading "Professional Excel Development by Stephen Bullen ISBN
0-321-26250-6 which explains everything properly BUT if you are using Excel
2003 or XP then Microsoft have removed the Jet 4.0 OLEDB Provider!!!
Apparently it has been "depreciated". Bullen says it can be downloaded from
Microsoft but I can't find it. It hasn't been provided since Office 2000
apparently Sad

"OLE_Newbie" wrote:

> Where can I obtain a good Programmer's Reference Guide for JET OLE DB 4.0.
> That is the one that comes with Excel. I am fairly profiicient with writing
> macros in Visual Basic. I need to know the functions and syntax of statments
> such as:
>
> 'Open an ADO connection to the folder specified
> Set oConn = CreateObject("ADODB.CONNECTION")
> oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "Data Source=" & strFilePath & ";" & _
> "Extended Properties=""text;HDR=Yes;FMT=Delimited"""
>
> Thanks
>