Inserting Null values using Bulk Insert 
Author Message
 Inserting Null values using Bulk Insert
Hi all,
I am using Bulk Insert which works fine but the problem is
some rows have null values for some numeric columns and
then it gives me an error.
How can I insert nullvalues using bulk Insert.
I am not using any Format and I cannot change before bulk
insert as file is very big.
Thanks for the help in advance

Sat, 19 Aug 2006 23:08:05 GMT
 [ 1 post ] 

 Relevant Pages 

1. Open Client 10.0.2 Bulk Copy Inserting NULLs Instead of Correct Values

2. Error when bulk insert follows another large bulk insert

3. Help: Inserting null values into Jet database using ADO

4. inserting null values into not null column in Server 7.0

5. Export Data using DTS Import using BULK INSERT

6. Replacing empty fields with NULL after a BULK INSERT

7. Bulk Insert, fixed-length files, and Nulls

8. How to BULK INSERT NULL dates?

9. How to BULK INSERT NULL dates?

10. Bulk Insert Spaces and Nulls

11. Bulk Insert "Spaces and Nulls"

Powered by phpBB® Forum Software