Page 3 of 14PREVNEXT

Import data from Excel to a new table in Access 2007

Limits on the import process

You can't import everything

Before you start importing data, keep these limits in mind:

  • You only import single Excel worksheets, not whole workbooks.
  • You can import 255 columns of data into a table in Access. If your source worksheet contains more columns, and you need that data, you can import it into another table.
  • You can't import all types of data. For example, you can't import images. Also, if your worksheet uses formulas, you can import the results of those formulas, but not the formulas themselves.
Page 3 of 14PREVNEXT