Print This Page
Step 1 - Backup your copy of Safety Manager file or files, in the example below I made a folder called backup and copied my Safety Manager file and pasted it in a backup folder. Right click on the file name and click "copy"
Step 2 - Right click anywhere in the backup folder your created and click paste.
Step 3 - Open the backup Safety Manager file, do not open your main file or else this may cause issues with your data later.
Step 4 - Go to the Database Tools Tab, then to Access Database Icon as shown below.
Step 5 - Click the "Split Database" button
Step 6 - Click the "Split" button on the pop-up window, take note that the split database file name will end with "_be"
Step 7 - Database successfully split message appears. Click the ok button.
Step 8 - Locate the file in the folder you split the database file to, named "Safety Manager_be".
Step 9 - Open that file and then click on the "tbl-accident" object. This is the table to contains all the data for employee accidents.
Step 10 - Click the external data tab at the top of the menu, then click the Excel Icon.
Step 11 - Save the file to a location on your computer you would like, then click ok.
Step 12 - Leave this box unchecked, then click Close.
Step 13 - Located the Excel file you just saved and open it.
Step 13 - Delete any columns you do not need, by left clicking on the column to highlight it and then right click to delete it.
Step 14 - In the upper left corner click "file" then "save as". You will see a box appear like the one below. Click the drop down arrow and select "CSV (Comman delimited (*.csv). Then click ok.
Step 15 - Click "Yes" for once the box below appears.
Congratulations you have saved your data in .csv format