Excel Query
Hello all,
I have an Excel file that retrieves the data from an Access database via query. As you all know, once a query is created, a define name is created as well. The problem that I am having is I don't know how to delete the query. For example, I created a query with the define name called "Query A". Somehow, I messed up on the query. So I want to create a new one with the same define name "Query A". Then I deleted the define name "Query A". When I recreate the query, it tells me that there is a query created with the same name. Please help. Thanks. |
Excel Query
hi
right click anywhere within the query range. from the popup, click data range properties. when the property dialog pops up, at the top, uncheck "save query definition". you will get a popup warning you that this will perminently remove the query from the sheet. click ok on the popup then click ok on the property dialog, query gone. data will remain. delete data. Regards FSt1 "AccessHelp" wrote: Hello all, I have an Excel file that retrieves the data from an Access database via query. As you all know, once a query is created, a define name is created as well. The problem that I am having is I don't know how to delete the query. For example, I created a query with the define name called "Query A". Somehow, I messed up on the query. So I want to create a new one with the same define name "Query A". Then I deleted the define name "Query A". When I recreate the query, it tells me that there is a query created with the same name. Please help. Thanks. |
Excel Query
Hi FSt1,
Thanks for the information. I have one more question. I have deleted the define name for that query. Now if I right-click on the query range, I am not getting the option "Data Range Properties". In that situation, how can I delete that query? Thanks. Happy New Year! "FSt1" wrote: hi right click anywhere within the query range. from the popup, click data range properties. when the property dialog pops up, at the top, uncheck "save query definition". you will get a popup warning you that this will perminently remove the query from the sheet. click ok on the popup then click ok on the property dialog, query gone. data will remain. delete data. Regards FSt1 "AccessHelp" wrote: Hello all, I have an Excel file that retrieves the data from an Access database via query. As you all know, once a query is created, a define name is created as well. The problem that I am having is I don't know how to delete the query. For example, I created a query with the define name called "Query A". Somehow, I messed up on the query. So I want to create a new one with the same define name "Query A". Then I deleted the define name "Query A". When I recreate the query, it tells me that there is a query created with the same name. Please help. Thanks. |
All times are GMT +1. The time now is 06:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com