Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database import
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database import
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database import
Is the manual data based on calculations of queried fields? Cliff Edwards No, it is just additional information on each entry. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database import
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import from Excel into database using jet in VB.net | Excel Discussion (Misc queries) | |||
import database tabase | Excel Programming | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
Cell Format import from Database | Excel Discussion (Misc queries) | |||
Import of Database VB app into Excel Spreadsheet | Excel Programming |