updating query

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Hi,

I have an access 2000/2002 table and inport this data into excel via a
query. So far so good. I then add extra columns in excel with additional
data and here where my problems begins. When i "re-query" the extra columns
doesnt correspond with the other data anymore.

Anyone have an idea?
 
Hi, Michael--
In Excel, right-click your queried data and select "Data Range Properties"
(or, if you have the External Data toolbar exposed, click the "Data Range
Properties" icon). Then make sure "Insert entire rows for new data, clear
unused cells" and "Preserve column sort/filter/layout" are selected.

FYI, other options I find handy when re-querying are "Preserve cell
formatting" and "Fill down formulas in column adjacent to data."

Hope that helps.
Davi
 
Txs Davi,

But... I allready tried that, doesnt work and its driving me crazy!!!
Argh!!.
When looking at the option: "Insert entire rows for new data, clear unused
cells" and testing with data, it doesnt do what it says. A bug in Excel
perhaps?

I also tried it with inserting the extra columns in the data range and not
behind it but same effect.

Anybody else?

Michael
 
Michael, are you refreshing the data, or re-opening the query in MS Query,
running it and returning the data to Excel? I have had the same problem if
I re-open in MS Query rather than just refreshing directly from Excel....
 
Hi Davi,

Soz, but was on holiday.

Yes i am refreshing in excel. And what i have tried sofar did not help.


Greets
Michael
 
Back
Top