Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have a csv file which has some fields with missing values and I want to identify which all fields have missing values. I can also use as stored procedure to get the same content as of the excel file.
Can anyone suggest how I an achieve this using either CSV file or stored procedure.
I started with the following code using stored procedure.
OLEDB connection;
load *;
SQL ****** EXEC Stored procedure syntax*************;
But in the above syntax all null values disappear from the fields.
Thanks in advance.
Hi,
Can somebody help
I need to find all the fields which have missing values while loading from csv file.
Thanks in advance