Toad World® Forums

Import Table Data


#1

I am using Toad for Oracle Professional Version 12.1.1.1. When I use the “Import Table Data” utility, I can’t find anywhere where it will let me direct how to handle NULL fields. Actual NULL fields…no data, NOT fields with the word NULL in them. The only place I found anything about NULLS is where you can specify what to do when the word “NULL” is found in a string field. So,when I go to preview the results, I see where there were nulls.

I am trying to import from an Excel Spreadsheet.

Any ideas?

Thanks.


#2

normally, you shouldn’t have to do anything special - they should just import as nulls. Do you get errors on importing if you hit Next/Finish anyway?


#3

What happens is that the rows in the spreadsheet with nulls don’t get imported. So out of 2500 rows, I end up with 41.

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Thursday, August 13, 2015 3:50 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Import Table Data

RE: Import Table Data

Reply by John Dorlon

normally, you shouldn’t have to do anything special - they should just import as nulls. Do you get errors on importing if you hit Next/Finish anyway?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#4

Hm. Well, if you can send me your file and table definition I’ll be happy to help figure this out.

John.Dorlon@quest.com.

feel free to just send a few rows of fake data if you can’t send the real data.