EMS Import Error

Almost all of the columns in the Item table are non-nullable. If you don't have a value to enter, use '' (an empty string) for text values or 0 (zero) for numeric. Most of the date values are nullable, but if not you can either use getdate() or 'yyyy-mm-dd' to set a value.

what is 'my items database'? Access? Excel? How are you performing your import?

OK, I have exported the Item db. I have to enter " in the Notes, ExtendedDescription, SubDescription, Content and UsuallyShip inorder to be able to import the file with out getting the Non-Nullable error.

But now I have the " in those fields of my items. How can I get ride of them?

Bill

"Glenn Adams [MVP - Retail Mgmt]" wrote: