"Logan" wrote:

I need to create a table with data from an excel book

Where do you intend to create the table?

You will need to create as many tables as there are worksheets in the excel
workbook.

If you simply want a recordset, you can read a worksheet into it.

Need more information on what you are trying to do!