VBA code required to import data from multiple excel sheets of an excel file

[kishorvimal]

Hi,

I need vba code in ms access which can import data from all excel sheets from an excel file. I do not know name of sheets available in excel file.

it should create one table in ms access.

help is greatly appreciated

Vimal

 

[HiTechCoach]

I like to use Excel automation.

See: Import Data from Microsoft Excel