Exclude a column from data import

[Dooza]

Hi there,
I am using Excel 2003 and am importing live data into a sheet. Everytime
the page loads the current data is pulled in from an SQL 2000 view.

The person who wants to use this spreadsheet wants to put an extra
column in the middle of the data. I have created a null column in the
view so that it is blank, but when you insert something into the column
and and refresh occurs, the column quite rightly gets overwritten with
null. Is there a way to remove the data from just one column?

I understand (I think) that if the order changes, or if a row is deleted
from the table, the manually inserted data will be out of sync.

Cheers,

Steve

 

[FSt1]

hi
how are you importing the data???
if you are using microsoft query...not going to happpen. sorry.
if MSQ, the data being imported is a imported as a named range c (check
insert>name>define...) and all areas inside that range is reserved for the
MSQ. you can line formulas up to the left, right and bottom of the MSQ but
that's it. adding columns or rows to the center of the MSQ just screws things
up.
if your are importing another way. post back.

regards
FSt1

 

[CLR]

What I would do is to use macros to copy the data over to another sheet, in
the format I wanted.....4 columns, empty columnn, more columns etc and do my
work on that sheet...........when new data comes in, re-copy it with the
macro so things will go where you want them to............

Vaya con Dios,
Chuck, CABGx3

 

[Dooza]

hi
how are you importing the data???
if you are using microsoft query...not going to happpen. sorry.
if MSQ, the data being imported is a imported as a named range c (check
insert>name>define...) and all areas inside that range is reserved for the
MSQ. you can line formulas up to the left, right and bottom of the MSQ but
that's it. adding columns or rows to the center of the MSQ just screws things
up.
if your are importing another way. post back.

It is with MS Query, from a view in SQL 2000. Is there another way I
could get the data?

Steve