HowTo: work arround for the "Too many fields error"

[Joannes Vermorel]

I have some data currently in XML that I want to import into MS Access. It
is very simple numeric data with roughly 700 fields (scientific data). When
I try to import in MS Access the XML file, I got the "Too many fields"
error.

It seems that by default MS Access limits at 255 the number of fields. But
since MS Access is not a "toy" product, I guess that there must be some ways
of changing this limitation. Does anyone knows how to do it ?

Thanks,
Joannes

 

[Kevin3NF]

Break it into smaller tables organized by logical entities. You cannot get
around the 255 field limit. Or move to SQL Server.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[Joannes Vermorel]

Ok, thanks for the feed-back. I am afraid that the only solution for me is
"do not use MS Access". In my case, it makes no sense to break to the data
into smaller table because it's a true high dimension problem (up to 100k
dimensions). I was not expecting such limitation.

Joannes

If access is saying its too big, it's too big, break it down. If you

don't break it down greatly, your access will lag or become unstable...many
tables are the key, but too many is confusing and painful