Re: Mapping to/from Access and/or Excel

[Dan Kazzaz]

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