Import problem - Excel - 151 text columns

[Bill]

I have a spreadsheet (or tab delimited text file) with 151
text columns.

When I import the text columns into an Access table, I
get "Unparsable Record" failures.

Row three fails with field 61 and most subsequent fields.

Row four fails with field 67 and most subsequent fields.
etc.

How can I import 151 text items into an Access record?
Thanks.

 

[John Nurick]

Hi Bill,

Access has a limit to the number of characters allowed per record
(excluding memo fields). The limit is 2000 characters in Access 97 and
(depending on the language in use) rather more in later versions, but if
there's an average of 50 or 60 characters in each field the limit will
be reached after about 60 records.

Does this fit your situation?

If so, you could perhaps import the largest fields from your text file
as memo fields. Alternatively, given that any file with 151 columns is
almost certainly un-normalised, set up a proper relational structure in
Access and just import the relevant fields from the text file into each
table.

 

[Bill]

That was it. Thank you very much.

Bill

-----Original Message-----
Hi Bill,

Access has a limit to the number of characters allowed per record
(excluding memo fields). The limit is 2000 characters in Access 97 and
(depending on the language in use) rather more in later versions, but if
there's an average of 50 or 60 characters in each field the limit will
be reached after about 60 records.

Does this fit your situation?

If so, you could perhaps import the largest fields from your text file
as memo fields. Alternatively, given that any file with 151 columns is
almost certainly un-normalised, set up a proper relational structure in
Access and just import the relevant fields from the text file into each
table.

I have a spreadsheet (or tab delimited text file) with 151
text columns.

When I import the text columns into an Access table, I
get "Unparsable Record" failures.

Row three fails with field 61 and most subsequent fields.

Row four fails with field 67 and most subsequent fields.
etc.

How can I import 151 text items into an Access record?
Thanks.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.