Re: Mapping to/from Access and/or Excel

[Mark T. Kennedy]

Dan is correct here. Products having ODBC and/or native drivers to access database applications directly allows seamless message implementations. Eliminating all flat file integration. EDITALK has this functionality also a simplified "drag and drop" mapping tool. Mark Kennedy Dan Kazzaz wrote: 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

begin:vcard
n:Kennedy;Mark
tel;fax:208-361-5350
tel;work:919-657-1427
x-mozilla-html:FALSE
version:2.1
email;internet:[EMAIL PROTECTED]
adr;quoted-printable:;;201 Shannon Oaks Circle=0D=0A;Cary;N.C.;27511;USA
fn:Mark T. Kennedy
end:vcard