How do I use Excel to View, Sort, & Graph my Blue Skies data?
• Backup your data using the normal Blue Skies Accounting File ! Backup so if you damage your data you can always Restore it using Blue Skies. • Start Microsoft Excel as you normally would outside of Blue Skies Accounting – double click on it desktop icon, use the Windows Start button, etc. • In Excel, under the File pulldown menu, choose ‘Open…’ • Navigate to your transaction directory [probably c:\blue_sky\1998data for your 1998 year] • Then in the ‘Look in’ dropdown list, choose ‘dBase Files’ – all the .dbf files will be displayed. • Double click on the file to open. The first 4 characters is the type of data, the next four is the client number, and the file suffix always is ‘.dbf’. • Glve1000.dbf is vendor names & addresses for client#1000. Each vendor or customer is another line in this file. • Glac1000.dbf is the general ledger account numbers, their descriptions, the most recent balance forward, current amount, ending balance, budget amounts, etc. Each gl account is another li
