Ok, I'm trying to figure out how to paste a bunch of records from excel to an SQL table. Some fields will contain no data. When I paste into the table, it makes the fields that have no data Null. I set it up so any new records entered in the table and have fields that contain no data will be an empty string. i put a value of "" instead of Null. But when I do paste records it keeps the fields with no data as Null. Is there a way to make anything pasted, imported, or appended not created NULL values for fields that contain no data, either in the table design or within the excel spreadsheet, etc. Thanks in advance for any information.