Access Memo Filed Problem more than 255 character

[kashif.special2005]

Hi,</SPAN>

There is one field “Task Name” in Excel that length is greater that 255 character and when I am copying and pasting this excel data into Access it is not accepting character more that 255 when I define Memo data type for that field.</SPAN>

Please help.</SPAN>


Thanks,
Kashif

 

[Joe4]

See here: http://office.microsoft.com/en-us/a...een-access-and-excel-HP001095095.aspx#BMgsio4, especially this part:

- A common import problem - truncated data
If you find that Excel cells containing more than 255 characters are being truncated during import, see "Data Type" under Step 4: Things you should know before importing certain data types and elements, in the "Getting started with the import operation" section of this topic. This will explain that the Import Spreadsheet Wizard previews only the first 25 rows of Excel data in predicting the data type to assign to the field in the new table.
If you have a cell that contains 440 characters in the 36th row of data, for example, Access will not see the data in that row, and, instead of creating a field with the Memo data type, the wizard will create a field with the Text data type. How could you avoid this particular problem? By cutting and inserting the 36th row of data above the 25th row in the Excel worksheet. It's also important to ensure that the data in the columns of your worksheet have a consistent data type from row to row.