Record Too Large

[Ripper]

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?

 

[Jeff Boyce]

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

 

[Rick Brandt]

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?

There is a limit on fields of 255 and a limit on the bytes in a row of 2K.

 

[Ripper]

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

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