Hi,

I want to create an app that will copy and paste the content from some mdb files automaticaly to an sql server 2005 db. These db should have the same format(same number of tables etc like the access file). What i should use in vb6 to do that?something like ado or adodb? First of all i should create a db to sql but how i could do that with the same form of the access files i will check the content and i then i will create them one by one is there any simplier way?

thanks