View Single Post
  #32   Report Post  
Posted to microsoft.public.excel.misc
naulerich
 
Posts: n/a
Default Import data into seperate columns

Emailed you the response from the BA.

"Doug Kanter" wrote:

Is there a name for the reporting capability that you DO have? A product
description? I know some ancient Borland product veterans who might have
some tricks up their sleeves, but I'd need to tell them what you've got.


"naulerich" wrote in message
...
I know that the capability to export to Excel is there however, I have
been
told that is outside of the reporting functionality we purchased. Bottom
line, we are trying to find a work around, currently the data is being
maniputlated close to 20 hrs per output (not sure what takes so long...)
to
get into the pretty excel colums. I believe that the final reason for the
output in excel is for R&D tracking of projects/deliverables. My comapny
LOVES excel, spreadsheet heaven here...

Can't very well ask Borland what to do...


"Doug Kanter" wrote:

Most database products allow the user to design outbound reports in any
way
that's necessary. Although programmers are as likely to do stupid things
as
the rest of the population, I'd be very surprised if Borland built that
product without the same report design features as their older products
(Paradox, Delphi).

This link takes you to the Borland support forums - I'd ask there about
whether you can design an export report that's more manageable than the
file
you're struggling with now:
http://support.borland.com/category.jspa?categoryID=3

This might take the discussion into another direction, but what's the
final
purpose of bringing all that text into Excel?

"naulerich" wrote in message
...
The text is coming out of a Borland database (Caliber), it will export
to
Word no problem however it is requested the output be in .xls format
which
is
not supported through the tools we have purchased through Borland. I
am
not
sure what control the BA has, other than setting delimiters when
exporting...What can I ask that the BA do to get a clean export?

"Doug Kanter" wrote:

Nichole, using the sample text you e-mailed me, I got the same results
you
did. This leads to another question - same one I asked yesterday:

Do you have any control over the program which PRODUCES the text file?
What
is that program?