Don,

I don't know you have a chance to read my reply to your message. Could you
help me how to delete the querytables permanently so that I can use the same
querytable names in the same worksheet and workbook?

I just remember why I need to re-use the same querytable names. The real
problem is somehow, I lose the connection(s) between Excel and Access from
time to time. When I lose the connection(s), I have to recreate the
connection(s)/querytable(s), and I have to reuse the same querytable names
because there are VB codes and formula for the workbook use those querytable
names. So I either reuse the querytable names or make changes to the codes
and formula. Since I do not know how to delete the querytable names
permanently, I have been making changes to the codes and formula, and it is
pain in the neck when you have to make a lot of those changes.

That's why, I need help with how to delete them permanently so that I can
reuse them.

Thanks.

"Don Guillett" wrote:

After you go thru your "delete" procedure go back and check to make sure you
clicked OK to make the change. Why delete and re-create when you can just
refresh???
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Souny" wrote in message
...
Hello all,

I have been looking for the answer to the question on how to delete the
querytables permanently, and I have not had any luck. I hope someone has
the
answer to my question. Please see below for detail information.

From the projects that I work on, I connect an Excel file to an Access
database to retrieve data. For the connection, I do not use code, instead
I
connect them through Data Import External Data New Database Query.
Part
of the connection setup, I give a querytable name and check the box "Save
query definition" in the External Data Range Properties. If I want to
delete
the querytable that I created, I uncheck the Save Query Definition box on
the
properties and delete the define name of that querytable. After I uncheck
and delete the define name of that querytable, when I recreate a new
querytable using the same querytable name that I just deleted, I would not
able to use it. I receive an error message that the name is already exist
on
that sheet.

I thought I deleted, and why would the querytable name still exist? Is
there a way to delete the querytables permanently so that when I want to
use
the same name again, I would be able to use it?

Thanks.