Ask the Expert

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.

Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: