connection string info

[spuppett]

Hey all, I was wondering if any of you know the ADO connection string for a foxpro(.dbf) database/table. I've been use DAO and its pretty straight forward there, but I'm having a **** of a time migrating to ADO. I can't seem to get dbf's to work at all, and that pretty much all we use here at work.

I've tried

Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
        "Data Source=N:/PERSONAL/awilliams/basic/;" & _
        "Extended Properties=dBASE IV;"     & _
        "User ID=Admin;Password="

where n:/personal/awilliams/basic/ is the folder with my dbf's.

I get "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another." error.

Any suggetions would be much appreciated.