attempting to connect to dbase III file via ado

[dwhawley]

i've been having a lot of trouble connecting to a dbase III file. here is my code

Set conDBF = New ADODB.Connection
conDBF.Provider = "Microsoft.Jet.OLEDB.4.0"
conDBF.Properties("Data Source") = cdlMain.FileName
conDBF.Properties("Jet OLEDB:Engine Type") = 11
conDBF.Open strCon

when i run this, i get an error stating that the selected file is an unrecognized database format. i tried the same thing with an excel file and got the same results. does anyone have any suggestion?

[dwhawley]

can anyone help me? this is worth more to me than just one cyber-beer. i'm willing to cough-up an entire cyber-case.

[dwhawley]

bar,

you are the winner of that case of cyber-beer! thanks a lot. i just created a new data link file and built the connection string in there. it works beautifully. thanks again. you're a life saver.

dwhawley