Database import

[humphrey.josh]

I have imported data to a worksheet from a query. No problems there.
Then I've manually input data into columns to the right of the
imported data. I'd like to keep the imported data and the data
manually input on the same rows, so i've check the "Insert entire rows
for new data, clear unused cells" option from the Data Range
Properties menu. However, when the imported data is refreshed, it
only adds cells instead of an entire row. Can anyone help with this
problem?

 

[ward376]

Then I've manually input data into columns to the right of the

imported data.  I'd like to keep the imported data and the data
manually input on the same rows

Is the manual data based on calculations of queried fields?

Cliff Edwards

 

[humphrey.josh]

Is the manual data based on calculations of queried fields?

Cliff Edwards

No, it is just additional information on each entry.

 

[ward376]

I believe that MS Query will clear any cells in rows in the query
range that aren't part of the query or formulas. You may have to make
some sort of lookup table to get the manual information on the correct
rows.

I usually keep seperate query sheets in my projects that only contain
the query and formulas that calculate additional fields, then copy
pertinent info to summary or report sheets.

If you resolve without using either of these methods, please post.

Cliff Edwards