Importing data from spreadsheet

[RPrasad]

Hi - I have multiple workbooks and within that there will be multiple worksheets. Number of workbooks and worksheets in that vary but the columns remain same. all put together there will be around 600K - 650K.

now I am looking to build a VBA in Access 2007 to import all the data into one table at one shot so I can write queries and perform the reporting activities..

Please help me with this. Thank you,

 

[RPrasad]

I have got some reference on http://www.mrexcel.com/forum/showth...ts-into-database&highlight=import+spreadsheet, need some help in looping the worksheets as the name of the worksheets and workbooks may not be same always. Thank you

 

[RPrasad]

Hi - can someone help me on the above question? Thank you,