Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Editing Queries in Excel 2000
Hi All,
I have a couple of queires that get data from an Access database and a text file on the network and display in an excel spreadsheet. I wanted to add new columns to these queries. I positioned the new columns where I wanted. But the problem is when data refreshes, the new columns are added to the end of list of columns, instead of the position I wanted. But when I remove the query and create a new query with the new no.of columns, it worked. But to do this is really painful, as I will have to redo all my page formats etc. Is their any workaround for this ? Thank you all in advance. Ravi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Editing Queries in Excel 2000
Rather than trashing your existing query, have you tried editing the
SQL and adding the new columns in the SELECT clause in the positions you want? -- "Ravi" wrote in message ... Hi All, I have a couple of queires that get data from an Access database and a text file on the network and display in an excel spreadsheet. I wanted to add new columns to these queries. I positioned the new columns where I wanted. But the problem is when data refreshes, the new columns are added to the end of list of columns, instead of the position I wanted. But when I remove the query and create a new query with the new no.of columns, it worked. But to do this is really painful, as I will have to redo all my page formats etc. Is their any workaround for this ? Thank you all in advance. Ravi |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Editing Queries in Excel 2000
The problem couldn't be you are using SELECT * in your queries rather
than specifying the column names, could it?! -- "Ravi" wrote in message ... Hi All, I have a couple of queires that get data from an Access database and a text file on the network and display in an excel spreadsheet. I wanted to add new columns to these queries. I positioned the new columns where I wanted. But the problem is when data refreshes, the new columns are added to the end of list of columns, instead of the position I wanted. But when I remove the query and create a new query with the new no.of columns, it worked. But to do this is really painful, as I will have to redo all my page formats etc. Is their any workaround for this ? Thank you all in advance. Ravi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing Queries In Excel 2007 | Excel Worksheet Functions | |||
Editing Comments - Excel 2000 | Excel Discussion (Misc queries) | |||
How can I protect a worksheet yet allow editing in Excel 2000 | Excel Discussion (Misc queries) | |||
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
ExcelXP 10 times slower than 2000 on web queries. | Excel Programming |