Importing Data

[shevek]

Hi,

I'm using Access 2002 to import data from a CSV/Excel file, an it does ok, except a memo field.

Although I don't know which is the max number of characters an excel cell can store, it seems the entire memo field is stored in spreadsheet, but when importing into access with the wizard, the field is truncated at the end and I cannot change data type pull down menu in field options in the wizard.

How can be this solved?

 

[RobJ]

I don't really know what you mean. Can you specify your question a little bit more. Or post the files

 

[neileg]

Access has a good bash at guessing the data type when you import a file, but it bases it on the first record.

If the first record of your file has a memo field with less than 255 characters, it will be allocated as a text field which has this size limit. Subsequent records will have the field truncated if it exceeds 255 chars. A memo field can contain 65,535 chars.

So, you can do one of two things
1) arrange that the first record's memo field has more than 255 chars, and Access will correctly interpret this as a memo field.
2) import into a predefined table where the field type is set to memo.

Does this help?

 

[Mrs.Meeker]

I came across this same issue and didn't know to change the location of my column, so I went ahead and imported it, then went into design and changed it to memo, and then pasted the column from excel over the trancated column in access. Seemed to work...but I"m just a hack.

 

[shevek]

Hi neileg,

The first solution works! I just changed rows order on the excel file and it works.

Thanks!