Handling Null Values in BULK INSERT
Posted on 2008-06-19
We have a Excel file which contains some 50000 records, now while uploading this Excel
we first convert it into Text formate. In this Text file the 50000 records will be saved and the remaining
15000 records will be "null".
Now while inserting this text file Using Bulk insert Command in SQL 2000, the "null" values
are also getting inserted in Databse which is not required
Can you please suggest a solution, where the "null" values can be avoided while running Bulk