If you want to use a query to put data in a worksheet, use a querytable.

If you use ADO to get data using an SQL statement, then you can use copy
form recordset and use your defined table as the anchor.

--
Regards,
Tom Ogilvy

"DSTDIVA3" wrote in message
...
A defined table in excel is when you give a range a name. When you
highlight
a specific range and click the box on the left and type a name in that box
then press enter, you have defined a table. When I execute the SQL
statement
to update the data, that's when I get an error.

"Tom Ogilvy" wrote:

What is a defined table?

If it a data pull, then it is updated by pulling data. (refresh the
table)

--
Regards,
Tom Ogilvy

"DSTDIVA3" wrote in message
...
I have been having problems copying data from one spreadsheet to a
defined
table in another spreadsheet. I would get all kinds of errors such as
the
table is not updatable or the object is not recognized. I am doing
this
in
VB. Does anyone have any insight about the situation?