
Connection String for Text Jet OLE DB Provider ???
This is how I found out what connection string to use for MS Access, hoepfully
it will work for you.
Put an ADODC control on a form. Choose its properties. Click on the connection
string radio button. Click on build. chose your Jet driver, then chose your
databse. When your all done you will have a connection string. Just use
Cntrl-C to copy it and then paste it into your code.
*:> Scott
Somebody at MS really needs to get on the stick and get us some documentation.
Quote:
> Anyone know the syntax for the Connection string when I am using the Jet OLE
> DB Provider to read a CSV text file?
> I already have it working with the ODBC driver so already have the
> schema.ini file setup, however I don't know how to specify that I am using
> TEXT to the OLEDB Jet driver.
> I am using VisC++6 and ADO. All the examples in MSDN seem to be for VB
> accessing Jet directly.
> Steve