Anyone can help how to write the vb6 code for import excel data to my database file (mdb), because my excel have more than 10,000.00 code to manually key in to my database file. Another problem is my client computer doesn’t want to use Microsoft access to open the database file. Any other way to write the vb6 code for import to my database?

a.) I use the data control to connect to my database (mdb).

b.) When I click the command button1 will browse the excel file and commandbutton2 will import excel data file to my database (mdb).

Any one help is much appreciated, Thank you.