Increase Size of Field Name

[tonere]

Hello All,

I am importing data from an Excel file into Access 2010 that comes from a survey. The first row of the excel File contains the survey questions that have been broken down to give a brief summary of the actual question. I looks like Access only likes Field Names with length less than or equal to 65 characters.

Is there a way to increase this?

Thanks!

[pbaldy]

In 2000 the limit was 64 characters. Look up "specifications" in help which should help find the limits for your version.

[boblarson]

If you go here:
http://office.microsoft.com/en-us/ac...010030739.aspx

you will find that the name is still only 64 characters maximum that Paul had said. You'll probably need to use some code to truncate those names in the Excel file prior to importing.

[tonere]

Thank you both, I am limited to 64 characters.

Will try to truncate.

[pbaldy]

Thanks for the link Bob; I didn't realize the specs were no longer available through Help.

[boblarson]

Thanks for the link Bob; I didn't realize the specs were no longer available through Help.

Actually they are, but I just referenced it as the place I looked since I didn't have an installation of 2007 handy. It escaped my notice that you were trying to get the user to use the help file for more than just a means to take up space on their hard drive. It's been a wickedly bad Monday for me so my brain is not working at full capacity. My apologies.