Exceeded 255 rows in table

[mikew71]

I'm building a flat file to import into Access that has exceeded 255 rows, I have no other way around this and cannot split the data into seperate tables. Is there any way around this?

 

[jrbarnett]

I presume you mean 255 columns (fields) rather than rows, as Access can easily handle more than 255 rows.

Assuming that the data are fully normalised, the easiest way is to create a second table with the same primary key value and create a 1:1 relationship between them.

John