Past 255 rows 2

[PharmaFun]

Hi there...is it possible to put more then 255 rows of data in a table?

Thanks,
Dino

 

[willir]

PharmaFun

If you mean, can you enter more than 255 rows of data into a table -- absolutely. There lots of databases with 1,000's and 10,000's of records.

 

[PharmaFun]

Sorry..,..what I meant was can I have a table with more then 255 columns?

Thanks,
D

 

[GoDawgs]

No, but there are ways around that...although I'm not sure why you'd need that many columns. You can create a second table that has a one to one relationship with the first table...basically just a continuation of the data.

 

[smedvid]

Not in MS Access. There is a limit of 255 I think. Also, from a data design/model stand-point, you may not want to have a table that wide. I am dealing with some SQL Server/Oracle tables with 500+ columns. It is a mess. But, it is a COTS, and that is what u buy.

In my case, I needed to write (2) SQL Views to pull in just the fields I need. Linking to a SQL Server/Oracle table will only display 255 columns.

htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[willir]

Dino

Obviously there has to be limits. Oracle and Informix will be less restrictive than Access.

Do you really need 255 columns or fields? For example, when importing from elsewhere. Would you reconsider changing the design? If importanting, can you import in stages? For example importing with VBA code and splitting the data with logic in the code. This is similar to GoDawgs [\b] suggestion, or split it up into relational tables.

Good luck on this one.
Richard