# TOAD Data Point 3.6.1 import of empty Excel cell into Oracle DB **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [March 26, 2015, 6:56am UTC](https://forums.toadworld.com/t/toad-data-point-3-6-1-import-of-empty-excel-cell-into-oracle-db/32997 "2015-03-26T06:56:18Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![mario.velchev](https://avatars.discourse-cdn.com/v4/letter/m/8797f3/32.png) [@mario.velchev](https://forums.toadworld.com/u/mario.velchev)\ **Post date:** [March 26, 2015, 6:56am UTC](https://forums.toadworld.com/t/toad-data-point-3-6-1-import-of-empty-excel-cell-into-oracle-db/32997/1 "2015-03-26T06:56:18Z")
Hi, I’m using TOAD Data Point 3.6.1.3294. When I’m importing empty XLSX fields with date format into Oracle table the imported value is ‘01.01.0001 00:00:00’ instead of expected {null} value. When the same task is performed using old TOAD Data Point 3.3.0.1526 everything is Ok and null values are imported. I’m totally puzzled. Please help. BR, Mario ---
**Author:** ![Joshua.Liong](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/joshua.liong/32/193_2.png) [@Joshua.Liong](https://forums.toadworld.com/u/Joshua.Liong)\ **Post date:** [March 27, 2015, 10:29am UTC](https://forums.toadworld.com/t/toad-data-point-3-6-1-import-of-empty-excel-cell-into-oracle-db/32997/2 "2015-03-27T10:29:31Z")
To Mr. Mario Velchev. I regret I was unable to reproduce this issue. If you could provide us a sample XLSX file that reproduces on your end, we will be able to move forward from there. How to attach a file to a post 1. Post a Reply using Rich Formatting ![5step.png](https://global.discourse-cdn.com/quest/original/2X/b/b6efa016e3f4ab6da3f91a55ec06e8c214ba4d68.png) 2. Compose a message 3. Select the Options tab next to Compose, then click Click to Add to add the xlsx file ![7step.png](https://global.discourse-cdn.com/quest/original/2X/9/9a15c70697ad7148af472e95aa300269f3a78027.png) 4. Post when you’re ready! ---
**Author:** ![mario.velchev](https://avatars.discourse-cdn.com/v4/letter/m/8797f3/32.png) [@mario.velchev](https://forums.toadworld.com/u/mario.velchev)\ **Post date:** [March 30, 2015, 12:47am UTC](https://forums.toadworld.com/t/toad-data-point-3-6-1-import-of-empty-excel-cell-into-oracle-db/32997/3 "2015-03-30T00:47:52Z")
Hi Joshua, Please find attached following information: the data for upload into the table (xlsx and csv formats) and the script for table generation. BR, Mario [tmp.rar](https://forums.toadworld.com/uploads/default/original/2X/c/cd7681b32cb1b369eee236c6b8fc5d53297dda26.rar) (8.52 MB) ---
**Author:** ![GregDavis11009](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gregdavis11009/32/122_2.png) [@GregDavis11009](https://forums.toadworld.com/u/GregDavis11009)\ **Post date:** [March 30, 2015, 8:00am UTC](https://forums.toadworld.com/t/toad-data-point-3-6-1-import-of-empty-excel-cell-into-oracle-db/32997/4 "2015-03-30T08:00:33Z")
Mario, What database are you importing the data into? Sybase ASE does not allow null dates, it will default the date. If not Sybase you may have a database setting that is defaulting null values to basically day 1 of the calendar. ---
**Author:** ![GregDavis11009](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gregdavis11009/32/122_2.png) [@GregDavis11009](https://forums.toadworld.com/u/GregDavis11009)\ **Post date:** [March 30, 2015, 8:03am UTC](https://forums.toadworld.com/t/toad-data-point-3-6-1-import-of-empty-excel-cell-into-oracle-db/32997/5 "2015-03-30T08:03:24Z")
Also, SQL Server will default a null value to a date if you use certain functions like Coalesce. ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [March 30, 2015, 10:30am UTC](https://forums.toadworld.com/t/toad-data-point-3-6-1-import-of-empty-excel-cell-into-oracle-db/32997/6 "2015-03-30T10:30:50Z")
Several people tried importing this file on Oracle and SQL Server and we always get null values on end\_dtm. We cannot reproduce your issue. ---
**Author:** ![mario.velchev](https://avatars.discourse-cdn.com/v4/letter/m/8797f3/32.png) [@mario.velchev](https://forums.toadworld.com/u/mario.velchev)\ **Post date:** [March 31, 2015, 12:10am UTC](https://forums.toadworld.com/t/toad-data-point-3-6-1-import-of-empty-excel-cell-into-oracle-db/32997/7 "2015-03-31T00:10:11Z")
We are using Oracle 11.2.0.4 DB. I’m using Oracle 11.2.0 x64 client on my MS Win 7 x64 desktop. ---
**Author:** ![mario.velchev](https://avatars.discourse-cdn.com/v4/letter/m/8797f3/32.png) [@mario.velchev](https://forums.toadworld.com/u/mario.velchev)\ **Post date:** [March 31, 2015, 12:17am UTC](https://forums.toadworld.com/t/toad-data-point-3-6-1-import-of-empty-excel-cell-into-oracle-db/32997/8 "2015-03-31T00:17:25Z")
On the laptop with MS Win 7 x86 I’m using Oracle 10.2 client x86 and TOAD Data Point 3.3.0.1526. Using the laptop I don’t have the described above problem. BR, Mario [oracle.xlsx](https://global.discourse-cdn.com/quest/original/2X/b/bcd832a7a5426169a8cd132bf0d43530dc590a36.xlsx) (10.8 KB) ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [April 2, 2015, 4:58pm UTC](https://forums.toadworld.com/t/toad-data-point-3-6-1-import-of-empty-excel-cell-into-oracle-db/32997/9 "2015-04-02T16:58:12Z")
I thought maybe the 64 bit client was the issue but I tried that and the null date column imported as null. What date format are you using in the grid? Look in Options | Grid ---
**Author:** ![mario.velchev](https://avatars.discourse-cdn.com/v4/letter/m/8797f3/32.png) [@mario.velchev](https://forums.toadworld.com/u/mario.velchev)\ **Post date:** [June 22, 2015, 12:18am UTC](https://forums.toadworld.com/t/toad-data-point-3-6-1-import-of-empty-excel-cell-into-oracle-db/32997/10 "2015-06-22T00:18:43Z")
I’m using General date/time with seconds pattern (G). On the same machine I have old version of TOAD 3.4 and I don’t have such problems when I’m importing null values from xlsx files. ---
**Author:** ![Kiki](https://avatars.discourse-cdn.com/v4/letter/k/dc4da7/32.png) [@Kiki](https://forums.toadworld.com/u/Kiki)\ **Post date:** [July 9, 2015, 9:08am UTC](https://forums.toadworld.com/t/toad-data-point-3-6-1-import-of-empty-excel-cell-into-oracle-db/32997/11 "2015-07-09T09:08:14Z")
I tried several combinations including uncheck this checkbox but cannot reproduce the issue you reported. Could you provide your import template for us to investigate? ---
**Author:** ![mario.velchev](https://avatars.discourse-cdn.com/v4/letter/m/8797f3/32.png) [@mario.velchev](https://forums.toadworld.com/u/mario.velchev)\ **Post date:** [July 12, 2015, 11:55pm UTC](https://forums.toadworld.com/t/toad-data-point-3-6-1-import-of-empty-excel-cell-into-oracle-db/32997/12 "2015-07-12T23:55:30Z")
Hi Kiki, Please find it atached. [import.rar](https://global.discourse-cdn.com/quest/original/2X/1/18e4b268042ff418736e2cffc8373ee1d611a1aa.rar) (1.07 KB)