Jaynet,
Office 2010
Access version 14.0.6112.5000 (32-bit)
I tried the import in safe mode and received the same error;
My data set:
Purchase Order Number,PO Date,Vendor #,Pupose Code,Currency,BillName,BillAddress ,BillCity,BillState,BillZip,Name,ShipAddress ,ShipCity,ShipState,ShipZip,FOB,SCAC Code,Routing,Terms Type code,Terms basic date code,Terms net days,3P,Divison Number,Information
contact,Telephone,Information contact,Telephone,Email Address,Reseller/Customer name,ResellerAddress,ResellerCity,ResellerState,ResellerZip,ResellerCountry,Information contact,Telephone,Information contact,Telephone,Email Address,Requested Ship date,Message
field,Line item,Quanity,Unit of measure,Ingram part number,Manufacturer part #,Product Description,Media,Unit cost,Extended cost,Message Text
60N3821D,20120119,U567,Original,U.S. Dollars,Ingram Micro,1600 E. St Andrew Place,Santa Ana,CA,92799,Lela,1759 Wehrle Drive,Willamsville,NY,14221,TP Destination,ABFS,ABF Freight,14,,45,Collect,U567,Angelina Gutierrez,7145661001,Ian Olsen,7145661001,ian.olsen@ingrammicro.com,,,,,,,Ian
Olsen,7145661001,Ian Olsen,7145661001,ian.olsen@ingrammicro.com,20100220,Message,LineItem1,1,EA,CH3521,ManfProd1,ProdDesc1,,1.55,1.55,Message1
60N3821D,20120119,U567,Original,U.S. Dollars,Ingram Micro,1600 E. St Andrew Place,Santa Ana,CA,92799,Lela,1759 Wehrle Drive,Willamsville,NY,14221,TP Destination,ABFS,ABF Freight,14,,45,Collect,U567,Angelina Gutierrez,7145661000,Ian Olsen,7145661000,ian.olsen@ingrammicro.com,,,,,,,Ian
Olsen,7145661000,Ian Olsen,7145661000,ian.olsen@ingrammicro.com,20100220,Message,LineItem2,1,EA,CH3522,ManfProd2,ProdDesc2,,2.56,2.56,Message2
My error results:
EDI 850 sample file in drop box_ImportErrors
Error |
Field |
Row |
Type Conversion Failure |
Telephone |
1 |
Type Conversion Failure |
Field27 |
1 |
Type Conversion Failure |
Field36 |
1 |
Type Conversion Failure |
Field38 |
1 |
Type Conversion Failure |
Telephone |
2 |
Type Conversion Failure |
Field27 |
2 |
Type Conversion Failure |
Field36 |
2 |
Type Conversion Failure |
Field38 |
2 |
<tfoot></tfoot>