I have an Access 2007 file with 236 columns.  When I try opening it or importing it into Access 2013 all of my columns are there, but it will not let me add more columns in either mode (too many fields).  If I open a new table I can make it have 255 columns.  Any idea on how to fix this?  I have only one key column.

• Moved by Lanlan HuangMicrosoft contingent staff Friday, April 10, 2015 5:31 AM

Hi KrisMarshall7,

In regarding of the issue, please provide us more information to assist you better.

• What the file format is your Access 2007 file? MDB or ACCDB?
• Where do you want to add the columns? Table, form or query?

As far as I know, the limitation of columns in a table is 250. Thus, I suppose that the database had some hidden columns. Please try to check it. Steps:

Right-click any field title, then select Unhide Fields. A dialog box will appear. Click the check boxes of any fields you would like to be visible again, then click Close.

Hope it's helpful.

Regards,

George Zhao
TechNet Community Support