Question on Deleting Querytables

[Souny]

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.

 

[Don Guillett]

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.

 

[Souny]

Don,

Thanks for your response.

I don't know what you mean by "check to make sure you clicked OK to make the
change". Could you tell me more?

In addition, the delete procedure that you are referring to is it deleting
define name of the querytable and removing check from the Save Query
Definition box from the Properties?

The reason that I want to delete the querytable and recreate a new one with
the same name is sometime, I use the wrong query from Access database for
querytable and I have to change it, but I want to keep the same querytable
name. I have tried to change the query within the querytable window, and I
couldn't.

Thanks again.

 

[Souny]

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.