You need to use SQL statements ?
If so you will need to use ADO or DAO, although I have not use these types
of SQL on Excel, but I suppose it should work.

But you say this is written in Excel.
So why not just :
Dim NewWS as worksheet
set newws=ThisWorkbook.Worksheets.Add
newws.range("A1").value="New data"

But depends what you mean by a "table" ?

NickHK

"Britt" wrote in message
...
Hi,

I want to create a table programmatically in excel. How can o do this
("create table ....")??
And then, how to put it in specific cells in the worksheet, and possibly
put it into sheet2 of the same worksheet?

Thanks for gelp
Britt