Exam 3: Creating and Using Queries

Correct Answer:

Verified

Common errors that occur when creating a new table or appending to an existing table include the following:
• Error with importing the file: If an import process fails completely,the table is not created or updated and an Import Spreadsheet Wizard message box displays the "An error occurred trying to import file" message.Read the additional information provided in the message box to determine the corrective action needed.Cancel the import and make the necessary corrections before trying to restart the import process.
• Subscript out of range: A common error that causes a failed import is "Subscript out of range." If you receive an Import Spreadsheet Wizard message box with this message you may need to cancel the import and recheck the following items: (a)Verify that all the column headers are the same as the existing table.(b)Verify that all fields in a column have the same data type and that the data type matches the existing Access table.(c)If,after correcting those problems,the message box still displays,close and reopen Access before restarting the import process.
• Primary key error: If you attempt to add records where the primary key column contains inconsistent,missing,or duplicated data,an Import Spreadsheet Wizard message box displays alerting you to the primary key problem.In most cases,the table is still created and the data imported.Open the table to correct any fields that may have invalid data.If you are appending records,in most cases,the data is not appended to the table.