The easiest mapping is to output a delimited file - comma, pipe,
whatever you feel good about and isn't present in the data. Excel and
Access will import them with no problem. You can also give Excel and
Access hints about the data by surrounding the text data with quotes and
inserting the decimal points into numerics. You can also send a
fixed-length formatted flat file, but you'll have to do some extra work
to import.
(Hopefully your mapper will cooperate.)
Christopher Peterson wrote:
>
> 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
>
> __________________________________________________
> Do You Yahoo!?
> Talk to your friends online with Yahoo! Messenger.
> http://im.yahoo.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/
--
%%%%%%%%%%%%% cut here %%%%%%%%%%%%%%%
Brian Lehrhoff ([EMAIL PROTECTED])
EDI Consultant
Dynamic Web Enterprises
973-276-3114
%%%%%%%%%%%%% cut here %%%%%%%%%%%%%%%
=======================================================================
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/
