Transferring Data From Access

[philhert]

I have set up a worksheet to Get External Data from my DB (ex LastName,
FirstName). I then use the worksheet to input additonal data for each row.
When I refresh the Data (after I have made changes in the DB), is there a way
to preserve the row info, as new names may be inserted in between original
names?

Ex. co1 col2 col3 col4
orig data: jones tom xxx xxx
wesson mike xxx

after refresh: jones tom xxx xxx
smith joe xxx
wesson mike

wanted: jones tom xxx xxx
smith joe
wesson mike xxx


Is it possible to preserve the row data?

thanks for any help

phil

[Debra Dalgleish]

The data typed adjacent to the external data isn't connected to the
names, so won't automatically shift if the imported data changes.

You could enter the data in the database, connecting it to the names.
Or, create a lookup table of names and data in the Excel workbook, and
use formulas adjacent to the external data, to display the matching data.

philhert wrote:
> I have set up a worksheet to Get External Data from my DB (ex LastName,
> FirstName). I then use the worksheet to input additonal data for each row.
> When I refresh the Data (after I have made changes in the DB), is there a way
> to preserve the row info, as new names may be inserted in between original
> names?
>
> Ex. co1 col2 col3 col4
> orig data: jones tom xxx xxx
> wesson mike xxx
>
> after refresh: jones tom xxx xxx
> smith joe xxx
> wesson mike
>
> wanted: jones tom xxx xxx
> smith joe
> wesson mike xxx
>
>
> Is it possible to preserve the row data?
>
> thanks for any help
>
> phil


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

[philhert]

Thanks for the reply. I think I know just enough to get me into trouble. Is
the formula you are talking of something like VLOOOKUP? I have tried to
understand the help menu for that but am lost.

I have 15 columns of info, the first two come from the DB, the other 13
(which I want to keep with each name) contain either a ‘1’ or are blank.
Does each separate row have a formula?

Any additional help is appreciated.

Phil


"Debra Dalgleish" wrote:

> The data typed adjacent to the external data isn't connected to the
> names, so won't automatically shift if the imported data changes.
>
> You could enter the data in the database, connecting it to the names.
> Or, create a lookup table of names and data in the Excel workbook, and
> use formulas adjacent to the external data, to display the matching data.
>