As a general thought, you might just map from/to a format from/to which
Excel(r) or Access(r) can "import" or "export. " I believe both products can
import/export fixed-field-size or comma-separated-value data.
Depending your mapping software and hardware platform, you might be able to
map in "realtime:" Access supports an OBDC interface (don't know if that's
available for Excel); and, if you are really interested, you could write
part of your mapping system as a DDE server or client (depending on document
direction), as both Access and Excel are DDE-client-and-server-capable.
However, the OBDC and DDE solutions will result in you spending more time
"getting the applications to talk to each other" than "getting the
information you need." EDI is, by definition, a batch process anyway, so
what's one more step to "import" or "export?"
Michael C. Mattias
Tal Systems
Racine WI
[EMAIL PROTECTED]
-----Original Message-----
From: Christopher Peterson <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, January 26, 2000 1:19 PM
Subject: Mapping to/from Access and Excel
>Subject: Mapping to/from Access and Excel
>
>I would like to solicit the valuable assistance of the
>EDI List Serve family.
>
>I need to be able to map to/from an Excel Spreadsheet
>and an Access Database, to keep track of various
>reports that we can not generate from our MRP system.
>I am somewhat new to mapping, and am not sure how to
>proceed. Could someone walk me through in basic steps,
>what I would need to do, to make this happen.
>
>Thanks in advance for the assistance.
>
>Christopher Peterson
>EDI Specialist
>
=======================================================================
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/
