EDI file to MS access

[Treason]

Has anyone ever tried to import an EDI file into MS access?

I suppose I can code it myself, but it is plenty of work...

Maybe someone can take out the leg work for me?

Thnks

 

[sparx]

What format is your EDI file? I'm not sure what you are asking here, as I import EDI files into Access all the time, coming from different companies.

 

[jfgambit]

Treason:

What file type is your EDI format in? Most EDI transactions can be sent in a flat text file format (EXTOL Protal for example). But usually, it is tailored to your company. Each Carrier/Vendor sending EDI information should be structured to match your format. If you are recieving these transactions via a flat or comma delimited text file then you should be able to creatre a standard import for the information.

If your are trying to get the information from an SAP or TMS system, then it is still possible, but needs to have two actions, one to export from the system (BW report in SAP or SQL from a TMS) and then the import into Access.

HTH