Q

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

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchServerVirtualization

SearchCloudComputing

SearchExchange

SearchSQLServer

SearchWinIT

SearchEnterpriseDesktop

SearchVirtualDesktop

Close