Opening Excel files in AccuZIP6

Exporting expressions and information including exporting data in presort order or import order, and importing information, along with error messages that may apply to this category.

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Eric
Moderator
Posts: 1910
Joined: Tue Sep 19, 2006 3:29 pm
Contact:

Opening Excel files in AccuZIP6

Post by Eric » Tue Feb 02, 2010 3:21 pm

When you cannot open an Excel Document there are special characters in the Excel Document such as Carriage Returns and/or Line Feeds when they save as a flat file such as CSV or TAB Delimited Text, then follow these steps to import into AccuZIP6 5.0 properly:

1. Double-click on the Excel Document to open in Excel
2. From the File menu, choose Save As > Other Formats…
3. From the “Save as type:” drop down, select “Microsoft Excel 5.0/95 Workbook (*.xls).
4. Click Save.

Open AccuZIP6 5.0 and use File > Open List (or in the Open/Create screen, choose Open a list for the first time) to open the .xls document that you created.

The file will import properly, regardless of the special characters.
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply