import Excel or CSV- long text (memo)

[Rob W]

A large cell is getting cut off when I import XLS file. I do not understand

When I import CSV the data is not aligning with the fields.

Anyone with a solution to importing the XLS.

I am downloading CSV and bringing into XLS, which is fine.

 

[Ken Snell [MVP]]

Use TransferText with an import specification to import the csv file
directly.

 

[Rob W]

Thank you. I will try it.

I am little confused. When I import, Access recognizes size and defines
field as memo. But proceeds to cut the field (I did not count the characters)

Again, thank you.

 

[Ken Snell [MVP]]

If you use File | Get External Data | Import to import the spreadsheet, you
will truncate text strings longer than 255 characters because that feature
uses an older version of EXCEL format. TransferSpreadsheet is the better way
to import EXCEL files.

 

[Rob W]

Thank you.

I just used the transfertext and transferspreadsheet method.

transfertext only brought in the first record
transferspreadsheet brought in all records

Both concatenated the memo field to 254 characters.

Any recommendations?

 

[Ken Snell [MVP]]

I think we're running two separate threads on this same subject/question.
Let's stick with the other thread, ok?