Using Jet OLEDB Provider for non CSVs text files

Do you have any information on using the Jet OLEDB Provider for mapping onto other than comma seperated values (CSVs) text files. There is no documentation on Microsoft's Web site. The extended properties include the FMT=Delimited name/value pair which leads me to wonder if there are other values for FMT or if there is another property for other delimiters.
From what I gather, the Jet OLEDB provider will only handle comma separated values text files. However, if you have an interesting format you want to access through OLEDB, Microsoft does make that very easy. You just have to write a custom OLEDB provider. I have never written one, but they don't look that hard to do. Fortunately, my good friend Dino Esposito wrote an excellent article for the June 1999 Microsoft Systems Journal that shows you exactly what you need to do. You can read his article or search for "Exposing Your Custom Data In a Standard Way Through ADO and OLE DB" on your MSDN CD.
This was first published in March 2001

Dig Deeper on Windows Operating System Management



Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:









  • VDI assessment guide

    Wait! Don't implement VDI technology until you know your goals and needs. A VDI assessment should consider the benefits of a VDI ...

  • Guide to calculating ROI from VDI

    Calculating ROI from VDI requires a solid VDI cost analysis. Consider ROI calculation models, storage costs and more to determine...

  • Keep the cost of VDI storage under control

    Layering, persona management tools and flash arrays help keep virtual desktop users happy and VDI storage costs down.