vivienwwp

Hi guys..

I'd like to know how to insert excel sheets into an Access database. This is what I'm trying to do:

1. I have VB user interface. This is connected to the mdb using ADODB.Connection. From here, whatever the user inputs goes into the mdb. No problems here.

2. The user also needs to select a certain excel sheet (maybe from a combo box) and VB will extract data from the excel sheet.

Question: How do i put these numerous excel sheets into the mdb and allow user to select it?? Can I put these excel sheets displayed on a combo box on the user interface??

Shurik12

Hi,

Please have a look here:
http://support.microsoft.com/default...b;EN-US;257819

Regards,
Shurik.