Excel import to Access

[nicolasdiogo]

I have being required to import a number of Excel workbooks into Access XP.

I would like to be able to import all the worksheets into access as simgle tables into access.

For exemple:

the worksheets; January 1998 will be imported as a table called January 1998 where the first line of Excel will be the column name.

And the same goes for every single worksheet.


I have created a module that imports a worksheet, but i would like to import the whole workbook in one goal.

I would very much appreciate your help.

Thanks

Nicolas

 

[DonkeyOte]

Nicolas - if you're coding this in Excel then you should be able to place your existing worksheet code into a loop for each worksheet in the workbook so as to import each sheet individually.

Can you post your existing code?