Sounds like your export environment does all or no fields - can you not
specify only certain fields?
When "importing" with XL make sure you specify "parsing" to force text
on certain columns - don't just open the file with XL or you may get
unexpected results. Our Accountants often open csv files with XL -
stripping off leading zeros on codes. To "import", unfortunately, you
must navigate to the folder to find your file - not good if you want to
quickly work on a whole bunch of files.
Hope this helps,
Daryl
________________________________
From: delphi-boun...@delphi.org.nz
[mailto:delphi-boun...@delphi.org.nz] On Behalf Of Ayers, Stephen
Sent: Tuesday, 15 September 2009 13:12
To: Gary T. Benner
Cc: delphi@delphi.org.nz
Subject: Re: [DUG] Exporting to excel autoformat
I have already tried this, and yes that works, but now I have
double quote around all my numbers which I do not want.
Steve Ayers
Analyst Programmer
FUJITSU NEW ZEALAND
PO Box 493, Palmerston North Central, Palmerston North 4440
T +64 6 953 6807
stephen.ay...@nz.fujitsu.com
<mailto:stephen.ay...@nz.fujitsu.com>
nz.fujitsu.com <http://nz.fujitsu.com>
P Please consider the environment before printing this email
________________________________
From: Gary T. Benner [mailto:g...@benner.co.nz]
Sent: Tuesday, 15 September 2009 1:05 PM
To: Ayers, Stephen
Cc: delphi@delphi.org.nz
Subject: RE: [DUG] Exporting to excel autoformat
[Reply]
HI Stephen,
Surround the data in double quotes when exporting. This forces
Excel to treat it as text.
kr
Gary
At 12:53 on 15/09/2009 you wrote
>To : delphi@delphi.org.nz
>CC :
>From: Ayers, Stephen, stephen.ay...@nz.fujitsu.com
>Content Type: text/plain
>Attached:
>
>
>Hi
>
>We have an option to export out reports to excel rather than to
screen.
>An issue I have come across is that some fields are getting
auto
>formatted to dates. For example 200438-2 gets turned into
01/02/3830.
>Yet 456381-1 doesn't. I don't want any of these fields turning
into
>dates. Has anyone come across this issue before when importing
into
>excel.
>
>thanks
>The information contained in this email is privileged and
confidential and
>intended for the addressee only. If you are not the intended
recipient, you
>are asked to respect that confidentiality and not disclose,
copy or make use
>of its contents. If received in error you are asked to destroy
this email
>and contact the sender immediately. Your assistance is
appreciated.
>
>_______________________________________________
>NZ Borland Developers Group - Delphi mailing list
>Post: delphi@delphi.org.nz
>Admin: http://delphi.org.nz/mailman/listinfo/delphi
>Unsubscribe: send an email to delphi-requ...@delphi.org.nz with
Subject: unsubscribe
>
Gary Benner
________________________________
Semantic Limited <http://www.semantic.co.nz> - Online
Education, e-Commerce, Software Development & Systems Design
123 Internet Limited <http://www.123.net.nz> - Managed Web
Hosting, Virtualisation, High Availability Systems & Cluster
Technologies
Mob: 021 966 992
DDI: +64 7 543 1206
Email: g...@benner.co.nz
Skype: garybenner
Ref#: 41006
The information contained in this email is privileged and
confidential and
intended for the addressee only. If you are not the intended
recipient, you
are asked to respect that confidentiality and not disclose, copy
or make use
of its contents. If received in error you are asked to destroy
this email
and contact the sender immediately. Your assistance is
appreciated.
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.clearswift.com
**********************************************************************
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi@delphi.org.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject:
unsubscribe
