Advertisement

06.19.2008 at 02:36AM PDT, ID: 23498162 | Points: 500
[x]
Attachment Details

Handling Null Values in BULK INSERT

Asked by Venkatkp007 in SQL Server 2005

Tags:

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
Insert


 
  Start Free Trial
[+][-]06.19.2008 at 02:48AM PDT, ID: 21820637

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.19.2008 at 03:18AM PDT, ID: 21820764

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.19.2008 at 12:44PM PDT, ID: 21825737

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.20.2008 at 12:09AM PDT, ID: 21828950

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.20.2008 at 01:15AM PDT, ID: 21829207

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-42 / EE_QW_2_20070628