Re: Upload Excel spreadsheet to AS/400

[Michael_Hennessy@xxxxxxxxxxxxxxxx]

Simon / Clay,

thanks very much for your replies - we have a very happy A/P.

Between both your replies she was able to figure it - thanks to
everyone elsefor your input.

Regards, Mike Hennessy
Doubleday Australia.




"Simon Coulter" <shc@flybynight.com.au> on 07/12/2000 14:48:42

Please respond to MIDRANGE-L@midrange.com

To:   MIDRANGE-L@midrange.com
cc:    (bcc: Michael Hennessy/Doubleday/AU)
Subject:  Re: Upload Excel spreadsheet to AS/400





Hello ,

You wrote:
>How would you upload to the as400 from an excel spreadsheet with numeric
>data in it--considering that IBM does not like spaces in numeric fields.

     o Export it as a .CSV
     o FTP it to the AS/400 (if you didn't directly export it via
NetServer or ClientAccess)
     o Use CPYFRMIMPF to copy the CSV into a normal database file
(assuming you are on a release with that command)

Regards,
Simon Coulter.


«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
«» FlyByNight Software         AS/400 Technical Specialists       «»
«» Eclipse the competition - run your business on an IBM AS/400.  «»
«»                                                                «»
«» Phone: +61 3 9419 0175      Mobile: +61 0411 091 400           «»
«» Fax:   +61 3 9419 0175      mailto: shc@flybynight.com.au      «»
«»                                                                «»
«» Windoze should not be open at Warp speed.                      «»
«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---