Record Too Large

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a LARGE Fixed Length file to import. I have 1403 Fields in the file,
that I didn't create mind you. When I tried to import I received an error
message that said, "Record Too Large."

Does it mean too many records or, I fear, too many fields?
 
The maximum number of fields in any one Access table is 255 ... and you'll
find a strong consensus that anything more than 30 is very unusual.

The maximun number of characters in a single record/row is just over 2000.

Your "import" file certainly exceeds the first constraint, and probably the
second as well.

But since Access is a relational database, you don't NEED to have over 1,400
fields in a single table. Have you looked at the incoming data from a
relational design point of view?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Ripper said:
I have a LARGE Fixed Length file to import. I have 1403 Fields in
the file, that I didn't create mind you. When I tried to import I
received an error message that said, "Record Too Large."

Does it mean too many records or, I fear, too many fields?
Click to expand...

There is a limit on fields of 255 and a limit on the bytes in a row of 2K.
 
That was what I was looking at. I think I'll have to use the SSN as the
primary key of a series of imports that create multiple tables. Thanks for
your answer.
--

Rip


Jeff Boyce said:
The maximum number of fields in any one Access table is 255 ... and you'll
find a strong consensus that anything more than 30 is very unusual.

The maximun number of characters in a single record/row is just over 2000.

Your "import" file certainly exceeds the first constraint, and probably the
second as well.

But since Access is a relational database, you don't NEED to have over 1,400
fields in a single table. Have you looked at the incoming data from a
relational design point of view?

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
Back
Top