| | |
|
|
|
HowTo: work arround for the "Too many fields error" |
|---|
| message from Joannes Vermorel on 11 May 2004 |
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
|
| =?Utf-8?B?U0NITllERVM=?= replied to Joannes Vermorel on 11 May 2004 |
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
|
| Joannes Vermorel replied to =?Utf-8?B?U0NITllERVM=?= on 11 May 2004 |
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
"SCHNYDES" <anonymous@discussions.microsoft.com> wrote in message
news:308FB926-AD95-485B-AF1F-D831E1A2AB1C@microsoft.com...
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
|
| Kevin3NF replied to Joannes Vermorel on 11 May 2004 |
Break it into smaller tables organized by logical entities. You cannot get
around the 255 field limit. Or move to SQL Server.
|
|
Archived message: HowTo: work arround for the "Too many fields error" (Microsoft Access Error Message)
