Your problems with importing the text output from Report Builder into Excel
is likely due to inconsistant field deliniation in the import file. In
other words, Excel cannot accurately determine where one field starts and
ends consistantly. Try the following:
In the Report Builder file, add a special character (one that is NOT likely
to appear within the data itself - I use the "|" character - shifted
backspace on my keyboard) between each field on the report line. Also,
format the entire line to left align at the end of the previous field. This
will cause your output to look like this:
partno|description|123.34|999.9999|anytext ...
instead of:
partno | description | 123.34 | 999.9999 |
anytext ...
When you open the text file with Excel, indicate that the special
character is the delimiter and to NOT treat consecutive delimiters as one.
This should yield a more consistant data set that Excel can deal with
effectively.
Good luck
Jim Stetter
-----Original Message-----
From: Carol Engen [mailto:
cengen@...]
Sent: Tuesday, August 01, 2000 3:34 PM
To:
vantage@egroups.com
Subject: [Vantage] Exporting from Report Builder
I am looking for tips on Exporting from Report Builder to Excel. (allows
greater flexibility than the Export Utility within Vantage-calculations, Rep
Slips and Rates)
I am having trouble getting the column line-up to be clean during the Excel
import phase. Some Alpha fields are getting cut in the middle (I can always
delete the line...but I would like it to be fairly clean for handing off to
other users once the set-up is complete). Also, it appears if the Alignment
and Field Lengths aren't set up correctly portions of one column slide over
on an inconsistent basis to the column to its left. So far, I have used
trial and error to get what I want, but would very much appreciate some
tips.
Vantage 3.0 (still !)