Field Truncation

[Miskacee]

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!

 

[Chefjay22]

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.

 

[Miskacee]

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.

 

[Miskacee]

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.

 

[dealsforkd]

Hi, I am too facing the same problem. I tried to use import function ,
the Memo field is getting truncated.

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.
[vbcol=seagreen]

:

 

[hennie]

Just a thought and I am not sure if it will work. If you link the file
to Access and then run a make table query wont it solve the problem?

[

QUOTE=dealsforkd;7916079]Hi, I am too facing the same problem. I tried
to use import function , the Memo field is getting truncated.

 

[Miskacee]

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