Text Length Issue while importing

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

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.
 
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.
 
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
 
Stand corrected

MH said:
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
Click to expand...
 
Back
Top