Hi ,
I have an Access table that sources data from an outside source. Is it possible that the access table have the number of columns greater than 255 columns as the import has around 300 columns. Right now I am splitting the import into two parts and getting it in access, if I try to import the entire thing I get a parsing error.
Is there any way around this ?
If you've got a table with 300 columns that you are importing, you probably want to examine it carefully for normalization issues before just assuming that it will fit into a well-designed database! Sounds to me like the 'flat-file' design issue that is common with people who are more familiar with spreadsheet programs than relational databases.
And, as ADezii said, I also don't think there is any way to create a table with more than 255 columns in MS Access. (Nor should you really need to either!)
Regards,
Scott