Import Excel with more than 255 columns

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?
 
J

Jeff Boyce

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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
transferspreadsheet import text truncate 255 inconsistancies 1
255 Character Limit for Linked Excel data 1
255+ Column CSV Import 2
Importing large cell from Excel 2
Exporting more than 255 columns from Access 1
Importing XML File - Some Data Is Truncated 2
255 Characters and Import is frustrating me 9

Top