Page 13 of 14PREVNEXT

Import data from Excel to a new table in Access 2007

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


Always let Access create a primary key when you import data to a new table.

True

False

Rerunning an import appends data to a table.

True

False

Before you import data, you should use Excel to do the following:

Make sure your images render properly in your source data.

Remove any unwanted data, such as blank rows or columns, and fix any obvious errors such as #NUM.

Make sure your formulas are all on the same worksheet.

The import process has the following limits:

No more than 65,000 rows.

No more than 255 columns.

No more than 256,000 text characters.

No more than 1,024 images.

If you leave a column in your source data, you're stuck with it in your Access table.

True

False

Page 13 of 14PREVNEXT