Field Truncation

[Guest]

I am importing data from Excel to Access using the transfer spreadsheet
function in the macro. I have a cell that has more than 255 chrs (in excel).
Whenever I import this cell into Access, it only imports to 255 chrs. I
have the datatype set to memo on the Access field.

Any suggestions as to why, if the data type is set to memo it won't import
the entire data in the Excel cell?

Thanks!

 

[Guest]

You may want to export the file as a CSV or text file, then import the file
into Access. I know in Excel there is a limit to the visible characters in a
cell, I believe it is 255 characters. I would format your excel cells as
text before the export as well. Let me know if this helps.

 

[Guest]

I did export it via CSV. I can't format the excel cell as a text field
because it only allows 255 chrs. The cell in Excel has all of the data in it
(more than 255 chrs). Whenever I use transfer spreadsheet an import the csv
file, this particular cell imports with a 255 limit. I tried formatting the
excel cell to Text earlier and then also read it is limited to 255 where
General format is unlimited.

Any more suggestions?
Thanks.

 

[Joseph Meehan]

I am importing data from Excel to Access using the transfer
spreadsheet function in the macro. I have a cell that has more than
255 chrs (in excel). Whenever I import this cell into Access, it only
imports to 255 chrs. I have the datatype set to memo on the Access
field.

Any suggestions as to why, if the data type is set to memo it won't
import the entire data in the Excel cell?

Thanks!

What version of Access? In most if not all versions of Access the text
fields are limited to 255 characters. The memo fields allow more data.

 

[Guest]

I have Access 2000. I should be able to import the field in Excel that has
more than 255 chrs. into a memo field but can't quite figure out why this is
not working. I counted the imported data into Access and it was 255 chrs.
but my data type is memo.

 

[Joseph Meehan]

I have Access 2000. I should be able to import the field in Excel
that has more than 255 chrs. into a memo field but can't quite figure
out why this is not working. I counted the imported data into Access
and it was 255 chrs. but my data type is memo.

I am going on about something I really don't have good knowledge of and
I am to lazy to look it up.

As I recall not all methods allow a memo field to accept more than 255
characters. hopefully someone will offer that information and that it will
work for you application.

 

[Guest]

I solved this problem by resaving the file to .xls vs. csv. Everything came
across then.