Text Length Issue while importing

[Guest]

I am importing data from excel and one of the fields gets quite large. I was
hoping the new version of Access would allow larger text fields. Since that
hasn't happened, is there a built-in method to import a large text field into
the database? Maybe a mthod to automatically import to multiple columns?
Any help is appreciated.

 

[MH]

Use a Memo field when you are importing the file.

MH

 

[Guest]

Excel cells have a limit of 255 characters, coincidentally the same the
maximum size for Access fields. It sounds like you are concatenating
multiple Excel columns into a single Access column. Try using a Memo field
to hold the result, or alternatively import the columns "as is" and then
concatenate when needed in Access using queries.

 

[MH]

Taken from Excel help under "specifications":

Length of cell contents (text):
32,767 characters. Only 1,024 display in a cell; all 32,767 display in the
formula bar.

MH

 

[Guest]

Stand corrected

Taken from Excel help under "specifications":

Length of cell contents (text):
32,767 characters. Only 1,024 display in a cell; all 32,767 display in the
formula bar.

MH