David,
The column/field quantity limit will likely depend on the database you are
using. If 255 is not enough, I would take a look at the "normalization"
rules and see if you could redesign your table to reduce the number of
columns. I have never built or seen a table with more than roughly 50
columns. Any good database book and probably the documentation will have
information on normalization. Hope this helps.
Oscar Bowyer
Quote:
>Hello,
>I've written an import/export program using the data control. When I try to
>import/export to a file with more than 255 fields to a table I get an
error.
>Is 255 a built-in limit for a table? I don't want to be chasing phantoms.
If
>it's not a built in limit, can anyone point me in the right direction to
>solve my problem?
>Thank you.
>David Walonick