T
Teresa Robinson
Hi, all;
I'm using Excel as the repository for some Oracle records I'm
following in testing our application. One row is the record in the
text file, next row is the record after being imported to the DB, next
row is after another process, etc. and so forth.
Each row (after the first) is added using the Import External Data
wizard, which usually works just fine. The problem is that sometimes,
when the row is "put" into the worksheet, it seems to push all the
rest of the rows way out to the right, so that what used to be in
column A is now in column BD. That's one more column over from the
end of where the records end. I can't figure this out for the life of
me; I am also finding it difficult to fit a question into Google and
get any meaningful results. I've been to MVPS.org, also, and I just
can't find anything.
When I run the external data wizard, I go thru the routine, then when
it gets to the place where it asks where you want to "put" the data, I
make sure it's row X, column A, then go into properties to tell it not
to put in the field names and not to resize the cells. I thought that
was the problem, but any combination of field names or not, or cell
resizing or not, it doesn't matter, I still get this "column
insertion" (for lack of a better term) randomly.
Sorry for being long-winded. TIA!
I'm using Excel as the repository for some Oracle records I'm
following in testing our application. One row is the record in the
text file, next row is the record after being imported to the DB, next
row is after another process, etc. and so forth.
Each row (after the first) is added using the Import External Data
wizard, which usually works just fine. The problem is that sometimes,
when the row is "put" into the worksheet, it seems to push all the
rest of the rows way out to the right, so that what used to be in
column A is now in column BD. That's one more column over from the
end of where the records end. I can't figure this out for the life of
me; I am also finding it difficult to fit a question into Google and
get any meaningful results. I've been to MVPS.org, also, and I just
can't find anything.
When I run the external data wizard, I go thru the routine, then when
it gets to the place where it asks where you want to "put" the data, I
make sure it's row X, column A, then go into properties to tell it not
to put in the field names and not to resize the cells. I thought that
was the problem, but any combination of field names or not, or cell
resizing or not, it doesn't matter, I still get this "column
insertion" (for lack of a better term) randomly.
Sorry for being long-winded. TIA!