Field limit?

[obed]

Hi folks,

I am trying to import data from excel to access using ADODB connection and i have created 37 fields in the table for the same. however access table is okay till 28 field beyond which it shows INSERT INTO SYNTAX error. please help as to how can i import data to all 37 fields.

[June7]

Can have 255 fields in Access table. Need to analyze data and code. If you want to provide, follow instructions at bottom of my post.