I am importing data from excel into ms access.....I have made the data field a memo field but the text keeps getting cut off after an import. Do you know how I can get the text from cutting off during the import?
I am importing data from excel into ms access.....I have made the data field a memo field but the text keeps getting cut off after an import. Do you know how I can get the text from cutting off during the import?
usually in your data you will need to double up your " quotes in your string values. so in excel try "" sometimes its the the single quote as well. try fixing the double quote first then try the single as well. Access thinks that " means the end of the string.
in excel find and replace " with ""
After that try importing..
Hope this helps