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

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

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