> 
>Re: Import csv file into Access 2000 table with VB6 using DAO
>
>Is there a simpler way to import a csv file into an Access table other
>than inserting each line via an sql statement?  I think ADO can do it
>quite simply, but I am limited to using DAO.

Why are you limited to DAO? You are correct, ADO can do csv imports with 
1 
SQL statement.

Regards,
-Toby


I'm limited to DAO because the app needs to run on Win 95 with Access 2.0
Please don't tell me that I haven't needed to do this extra coding! (It 
wasn't that hard anyway)
Cheers
Alister