Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question on Deleting Querytables
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question on Deleting Querytables
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. "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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question on Deleting Querytables
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Question....Deleting Numbers In a Set | Excel Worksheet Functions | |||
Deleting a row - followup question | Excel Discussion (Misc queries) | |||
querytables.add question | Excel Programming | |||
Question about deleting rows and formulas | Excel Discussion (Misc queries) | |||
Newbie VBA Question; Deleting minimum value row | Excel Programming |