EDI--X12 Data Importing into Excel 97 Help 
Author Message
 EDI--X12 Data Importing into Excel 97 Help

Hello

I need to import a standard EDI-X12 flat file into Excell 97 does
anybody know of a macro or data converstion program that would do
this.

Thanks



Thu, 18 Jan 2001 03:00:00 GMT  
 EDI--X12 Data Importing into Excel 97 Help
If by flat file you mean ascii, then you can use File, Open to open the
file.  Or, open in an ascii editor, select all and copy to the clip board
and past into Excel.  You can then use the Text to Columns feature on
selected areas.

Bob Flanagan
Macro Systems - Microsoft Excel Solutions
http://www.add-ins.com
email:  BobF   at   add-ins.com



Quote:
> Hello

> I need to import a standard EDI-X12 flat file into Excell 97 does
> anybody know of a macro or data converstion program that would do
> this.

> Thanks




Thu, 18 Jan 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Access 2000 to ASC X12 Format for EDI

2. Access 2000 to ASC X12 Format for EDI

3. Filter for importing data from excel 97 in access 97

4. Importing Excel 97 data into Access 97

5. Importing Data to Access 97 from Excel 97

6. ANSI X12 214 file importing

7. HELP with EXCEL 97 import into ACCESS 97

8. Excel 97 - Import Data Functionality

9. Newbie ? Import Web data to excel 97

10. Import Web-Data into Excel '97 and automatically refresh on startup


 
Powered by phpBB® Forum Software © phpBB Group