MS Access & EDI

5 pts.
Tags:
Access
Database Management Systems
DBMS
EDI
Electronic Data Interchange
Microsoft Access
Is there a way to use MS Access to interface with a database that uses EDI? If so, what do I need to do to do this & where can I get more info on this?

Answer Wiki

Thanks. We'll let you know when a new response is added.

You will have to explain better what you mean about a database that uses EDI. MS Access can interface with many databases using ODBC. Simply create links to the tables or views that you want to access in the other database. EDI implies formatted input and output, you can create those using queries. Maybe some more information would help.

Thanks.

If the EDI file has been converted to a delimeted or fixed length text file for import to (or after export from the database), you can use VBA or VBScript from within MSAccess to read the text file into temp or permanent tables to do what you will with them. Some EDI VANs like TIE Evision have Conversion/Mapping programs and training to Convert true EDI Files to formatted text or XML files or Vice Versa. If you just need to export something from a database that once was EDI but now is just exported data. Those special programs and Week(s) long training probably would not be necessary.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following