Importing Data into Tables - Using Import Wizard - Null Values
Hi All,
I would like to use the data import wizard to import data into some existing staging tables, that are already populated with data.
However, when importing my CSV file, whilst the import completes without error, all the blank cells are populated with '(null)' - is there anyway to prevent this?
For example ColumnA has data for rows 1-11 and 15-30 but row 12-14 are empty, when uploading columnA using the wizard, rows 12-14 are populated iwht '(null)'. I would like to stop this from happening
Many thanks for your help
ROss