Be careful when opening a FirstOffice Export file with Microsoft Excel with the intention of editing it before importing it to a new database. Under certain circumstances, Excel will, when opening a text file, convert some variables that it interprets as dates into its own internal date format. Where you are expecting a date to appear in the spreadsheet you may see a number such as "35475". When you save the spreadsheet again as a text file these variables will not be converted back to date format. So, if you import this text file to FirstOffice, the dates will be wrong. To avoid this problem, make sure you use the third step of Excel's Import Wizard to set all imported columns to 'text' format (highlight all the columns in the Data Preview area using the Shift key and select 'Text' as the Column Data Format).

You cannot open files created using the 'Database Text Backup' and 'Company Text Backup' and 'Client Text Backup' functions in Excel as they are not text files.

Previous Next Top Entire Chapter in Printable Form