AccuZIP6 Users Community Forum Index AccuZIP6 Users Community
Tech Support, product information, postal news, and everything else concerning AccuZIP6
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Opening Excel files in AccuZIP6

 
Post new topic   Reply to topic    AccuZIP6 Users Community Forum Index -> Import/Export
View previous topic :: View next topic  
Author Message
Eric
Moderator


Joined: 19 Sep 2006
Posts: 382

PostPosted: Tue Feb 02, 2010 11:21 pm    Post subject: Opening Excel files in AccuZIP6 Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    AccuZIP6 Users Community Forum Index -> Import/Export All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group