"Record is too large" error on only 294 fields all set to Memo?

I don't understand this. There must be a setting I can change
somewhere.

I have a spreadsheet with 294 fields. I use an import specification
to bring the data from a text file. I am receiving an error called
"Record is too large" but I don't know why?

Any suggestions?

Thanks,

Nick

I need to make this clearer. I have data with 294 fields. It is
contained in a text file which is called by an access import
specification macro.

Fields or Records? An Access table can only have a maximum of 255 fields in
a table. If you exceed either the number of fields, you can not import it
into a single Access table.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

" wrote:

I need to make this clearer. I have data with 294 fields. It is
contained in a text file which is called by an access import
specification macro.

On Wed, 08 Aug 2007 10:06:50 -0700, wrote:

I need to make this clearer. I have data with 294 fields. It is
contained in a text file which is called by an access import
specification macro.

An Access Table (or Query) can have a maximum of 255 fields (an absurdly huge
width for any sort of normalized table); and the sum of the sizes of all the
fields in each record must not exceed 2000 bytes. Each Memo field contributes
16 bytes of overhead to that count, I believe.

You will need to import this monster into more than one table, probably using
VBA code.

John W. Vinson [MVP]

Thanks all!

fields in each record must not exceed 2000 bytes.

Still? Page size now 4K, but record limit still 2K?



"John W. Vinson" wrote in message
...
On Wed, 08 Aug 2007 10:06:50 -0700, wrote:

I need to make this clearer. I have data with 294 fields. It is
contained in a text file which is called by an access import
specification macro.

An Access Table (or Query) can have a maximum of 255 fields (an absurdly
huge
width for any sort of normalized table); and the sum of the sizes of all
the
fields in each record must not exceed 2000 bytes. Each Memo field
contributes
16 bytes of overhead to that count, I believe.

You will need to import this monster into more than one table, probably
using
VBA code.

John W. Vinson [MVP]

From Access (2003) Help - Access Specifications:
Number of characters in a record (excluding Memo and OLE Object fields) when
the UnicodeCompression property of the fields is set to Yes 4,000

Maybe you are thinking of an older version.
--
Dave Hargis, Microsoft Access MVP


"John W. Vinson" wrote:

On Wed, 08 Aug 2007 10:06:50 -0700, wrote:

I need to make this clearer. I have data with 294 fields. It is
contained in a text file which is called by an access import
specification macro.

An Access Table (or Query) can have a maximum of 255 fields (an absurdly huge
width for any sort of normalized table); and the sum of the sizes of all the
fields in each record must not exceed 2000 bytes. Each Memo field contributes
16 bytes of overhead to that count, I believe.

You will need to import this monster into more than one table, probably using
VBA code.

John W. Vinson [MVP]

On Thu, 9 Aug 2007 18:50:50 +1000, david@epsomdotcomdotau wrote:

fields in each record must not exceed 2000 bytes.

Still? Page size now 4K, but record limit still 2K?

It is in A2003; I don't know about A2007, don't have it installed.

John W. Vinson [MVP]

On Thu, 9 Aug 2007 08:06:02 -0700, Klatuu
wrote:

From Access (2003) Help - Access Specifications:
Number of characters in a record (excluding Memo and OLE Object fields) when
the UnicodeCompression property of the fields is set to Yes 4,000

Maybe you are thinking of an older version.

Thanks, Dave - obviously I was!

John W. Vinson [MVP]

On Thu, 9 Aug 2007 08:06:02 -0700, Klatuu
wrote:

From Access (2003) Help - Access Specifications:
Number of characters in a record (excluding Memo and OLE Object fields) when
the UnicodeCompression property of the fields is set to Yes 4,000

Help is forgetting people who don't use the roman alphabet. I guess it
should read something like this:

Number of characters in a record (excluding Memo and OLE
Object fields) when the UnicodeCompression property of the
fields is set to Yes *and* all characters are in the Windows
(Western) character set: 4,000
--
John Nurick - Access MVP