D
drabbacs
I'm stumped. I have a file I update on a weekly basis by
adding a sheet and importing external data into the newly
created sheet. The source data is a .xls file. The data is
contiguous and the file is roughly 100kb. The target file,
holds 13 of the source files and also has a couple extra
sheets for summary info. The file size with all of this is
approx 2 Megs.
Now I'm trying to make a similar tool for a new
application. Each source file is 2.5 Megs (.xls) and the
destination file is roughly 30 Megs. The data in the
source file(s) is not contiguous. There is a partial row
and there are 2 blank lines between entries. Each entry
starts with a partial row and then is followed by a
variable number of full rows. Then 2 blank lines and the
pattern repeats.
What is happening is, when I import external data it is
pulling the full rows with no problem. The partial rows
are only pulling the first column. The blank rows are
pulling just fine.
Why are the partial rows not being pulled in completely?
I've been using only the defaults in the import external
data menu. This is how I have done things with the old
file.
I have tried several permutations of settings but am
unable to determine what is going on. Does anyone have any
insight?
Example data follows
name02 name03 name04 name05 name06 name07 name08
name09 name10 name11 name12 name13 name14 name15
name16
0000000N1234 FILE ABC,5.75" LKJ
x 382 120 118 38 0 102 154
138 68 4 243 153 71 145
886531X 8 0 0 0 0 0 0
0 0 0 0 0 0 0
88653AX 2 0 0 0 0 0 0
0 0 0 0 0 0 0
I'm not sure if that will space correctly. There should be
5 lines. The first is the headers (name02,name03,etc), the
second is the 0000000N1234, File, ABC etc line and is the
one I'm only getting the 00000N1234 on. The 3rd and 4th
line start with 8865 and have columns of numbers following.
To restate my question, why does the line, 0000000N1234
FILE ABC,5.75" LKJ, get imported as
0000000N1234 ?
Thank you in advance for any help
Drabbacs
adding a sheet and importing external data into the newly
created sheet. The source data is a .xls file. The data is
contiguous and the file is roughly 100kb. The target file,
holds 13 of the source files and also has a couple extra
sheets for summary info. The file size with all of this is
approx 2 Megs.
Now I'm trying to make a similar tool for a new
application. Each source file is 2.5 Megs (.xls) and the
destination file is roughly 30 Megs. The data in the
source file(s) is not contiguous. There is a partial row
and there are 2 blank lines between entries. Each entry
starts with a partial row and then is followed by a
variable number of full rows. Then 2 blank lines and the
pattern repeats.
What is happening is, when I import external data it is
pulling the full rows with no problem. The partial rows
are only pulling the first column. The blank rows are
pulling just fine.
Why are the partial rows not being pulled in completely?
I've been using only the defaults in the import external
data menu. This is how I have done things with the old
file.
I have tried several permutations of settings but am
unable to determine what is going on. Does anyone have any
insight?
Example data follows
name02 name03 name04 name05 name06 name07 name08
name09 name10 name11 name12 name13 name14 name15
name16
0000000N1234 FILE ABC,5.75" LKJ
x 382 120 118 38 0 102 154
138 68 4 243 153 71 145
886531X 8 0 0 0 0 0 0
0 0 0 0 0 0 0
88653AX 2 0 0 0 0 0 0
0 0 0 0 0 0 0
I'm not sure if that will space correctly. There should be
5 lines. The first is the headers (name02,name03,etc), the
second is the 0000000N1234, File, ABC etc line and is the
one I'm only getting the 00000N1234 on. The 3rd and 4th
line start with 8865 and have columns of numbers following.
To restate my question, why does the line, 0000000N1234
FILE ABC,5.75" LKJ, get imported as
0000000N1234 ?
Thank you in advance for any help
Drabbacs