Troubleshoot importing records

Follow these steps to troubleshoot problems when trying to import records into WorkExpo from a Microsoft Excel spreadsheet.

Possible problem	Resolution
Column missing	In Microsoft Excel check that all required columns are present. If a column is missing then the import will fail. More Detail: The required columns are FirstName, LastName, DateOfBirth, Form, Homegroup, Street, Suburb, Postalcode, ParentName, ParentPhone and Note. All columns must be present including HomeGroup even if your school does not have homegroups. In this case, include the Homegroup column and column header but leave the column itself empty. Also ensure that columns are in the correct sequence as in the above list.
Header missing or not spelled correctly	Check that all headers are correctly spelled with no spaces in any of the header names. More Detail: Ensure that that there are no spaces in any header row name. The header row must always be Row 1. Compare the spelling of header row names with the following: FirstName, LastName, DateOfBirth, Form, Homegroup, Street, Suburb, Postalcode, ParentName, ParentPhone and Note.
Hidden column or row within the data	Check that there are no hidden rows or hidden columns in your spreadsheet. Hidden rows or hidden columns within the data will cause the import to fail. More Detail: Select the data area in your spreadsheet by choosing Select All from the Edit menu. Then from the FORMAT menu choose Column then Unhide. Then from the FORMAT menu choose ROW then unhide. Now deselect the data area and check if there are any empty rows in the data area or empty columns. If so delete these empty columns by selecting the column to delete and choosing DELETE from the EDIT menu.
Hidden data in spreadsheet	In Excel check that there are no columns to the right of the last data column (NOTE) containing blank information. More Detail: If there is hidden data anywhere in the spreadsheet even in columns outside the data area the import will fail. Try deleting several columns to the right of the last column (Usually the NOTE column). To delete these columns select the entire columns by clicking on the column headers and dragging to include several columns. Then choose DELETE from the EDIT menu. Save the spreadsheet and try again. Also check for rows below the last data row in the spreadsheet.
File format conflict	WorkExpo is a Microsoft Access database. There may be file format and version issues depending on the configuration of your machine and the version of Microsoft Excel you have. In this case save the spreadsheet in an earlier version of Microsoft Excel. Save your spreadsheet as an Excel 5.0/95 spreadsheet. More Detail: Systems are backwards compatible in Microsoft Office. Try saving the spreadsheet in Microsoft Excel version 5.0 format. To do this within Excel choose FILE then SAVE AS and in the Save As Type drop down box choose Microsoft Excel 5.0/95 workbook. Then try importing again.
Corrupt workbook	The workbook may be corrupt. If all else fails, create a new blank spreadsheet and copy and paste the selected data records into the new spreadsheet. More Detail: When you export from your school's database system into Microsoft Excel sometimes additional unnecessary macros and code modules are also exported and these may interfere with the import process. Open the spreadsheet containing the data you wish to import. Select ALL, then choose COPY. Create a new workbook and paste the data into the new workbook. Save then new workbook and try importing from this new file.
Error message Field ROW1 doesn't exist.	You are getting the error message Field'ROW1'doesn't exist in the destination table 'tblImportHeaders' When school data is exported to Excel it sometimes exports a "ROW1" column as the last column in the spreadsheet. This column is hidden but if you check the column headers you will notice that the sequence is missing a letter of the alphabet. Check the column to the right of the last data column and unhide it. Choose Format Column Unhide to see the hidden column. Remove this column completely by selecting the entire column and choosing Delete from the Edit menu.