Import Excel with more than 255 columns

  • Thread starter Thread starter Calendar Control
  • Start date Start date
C

Calendar Control

How do I get by the limitation of 255 columns for a table. I have an Excel
spreadsheet with much more than 255 columns that I need to import into a new
Access table. How can I get around this 255 limitation?
 
There's a reason they call it a limitation...<go>

Access is not a spreadsheet on steroids.

A well-normalized Access database table will rarely have more than 30
fields, so your presumption that you need to import all the existing Excel
columns into a single Access table is in error.

First, spend some time sketching out a well-normalized relational table
structure. Then map from the available columns to the tables' fields.
Perhaps you'll find you can import a more limited set of columns per table.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Back
Top