Programically add changing fields to a table

[johnseito]

Hello,

I am trying to add fields that keeps changing to a table, this field name is read from an excel file header. However I can only do it to like 8 fields and then an error message pops up that say



Record is too large, run-time error ‘3047’:

It was able to do it to the first 8 fields after that the error occurs. The xls file has 50 fields and can be more. Please advise.

[kd2017]

Lets see your code, access table structure, and excel table.

You're trying to modify the tables structure adding columns dynamically?

[johnseito]

Thanks kd2017 for looking into it. Yes I just figured it out. The reason for that problem was because when I added a field, I made it a character field which in access doesn’t have Char data type. I ended up changing it to text and it works.

[johnseito]

Sorry kd2017, I think I spoke to soon. Now I have another error message. It says “too many fields defined.”

Don’t know why it work last time. It’s like sometimes it works and other time it doesn’t. I am going to see when I could attach the codes.

[kd2017]

Are you trying to add more than 255 fields to a table? https://support.office.com/en-us/art...8-98c1025bb47c

I have to admit ether I don't understand what you're doing or what you're doing is pretty strange.

[orange]

Is this the same topic as https://www.accessforums.net/showthread.php?t=71253 ??