While I have never done so myself, for MS Excel you should be able to map to
and from a variable length CSV format file. Excel can import/export CSV
files.
Neil Flynn
CBSI
>From: Dan Kazzaz <[EMAIL PROTECTED]>
>Reply-To: Dan Kazzaz <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Mapping to/from Access and/or Excel
>Date: Wed, 1 Mar 2000 16:30:11 -0500
>
>I saw the original posting and did not have time to answer it.
>
>It certainly is possible to map to Access or Excel. However, it is product
>dependent. If the mapping tool you are using has ODBC capability you can
>do
>it. Without ODBC capability, it is difficult.
>
>Some mapping tools have ODBC capability by generating source code, others
>achieve it in more efficient methods.
>
>If your software vendor cannot support this capability, then you will need
>to write additional programs to parse the EDI message and post it into your
>database. There are several products on the market (including
>PaperFree's) that do not require this additional programming effort.
>
>Dan Kazzaz
>PaperFree Systems, Inc.
>
>
>-----Original Message-----
>From: Jasper Abeyta [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, March 01, 2000 3:14 PM
>To: [EMAIL PROTECTED]
>Subject: Mapping to/from Access and/or Excel
>
>Greetings,
>Several weeks someone asked the group if were possible to map to/from
>either
>Access or Excel. I suspect that most responses were sent directly to the
>individual since very few were posted for the groups benefit.
>
>I know how to do this with SPS, but is it possible to do this with
>Sterling's Gentran: Integrator? I called Tech Support and was told that I
>could not. In SPS when defining the flat file you can define it as a
>variable length. How would I do this with Gentran? Any and all
>suggestions
>would be appreciated.
>
>Thanks
>
>Jasper
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
=======================================================================
To signoff the EDI-L list, mailto:[EMAIL PROTECTED]
To subscribe, mailto:[EMAIL PROTECTED]
To contact the list owner: mailto:[EMAIL PROTECTED]
Archives at http://www.mail-archive.com/edi-l%40listserv.ucop.edu/
