PROBLEM WHILE WORKING WITH TEXT IMPORTER

[MURALI KRISHNA]

i want to load data from excel sheet to oracle table

i go like in plsqldeveloper
TOOLS--->TEXT IMPORTER----> OPEN DATA FILE --->AND THEN CHOOSE THE .CSV FILE---->DATA TO ORACLE --->AND THEN I CHOOSE OWNER NAME AND THEN TABLE NAME

MY PROBLEM IS IN FIELDS AREA THE COLUMNS OF THE TABLE ARE NOT DISPLAYED

CAN ANY ONE SEND THE POSSIBLE REASONS FOR THIS PROBLEM

 

[William Robertson]

If the file is locked because it's already open in Excel, Text Importer doesn't open it. Close Excel and try again.

 

[MURALI KRISHNA]

IS THERE ANY PROBLEM IF I PUT NULL EXPLICITLY FOR ONE COLUMN IN MS EXCEL SHEET WHILE LOADING DATA

LIKE

A B C
100 MURALIKRISHNA NULL

 

[MURALI KRISHNA]

THANK YOU WILLIAM ROBERTSON FOR YOUR REPLY

BUT STILL I AM GETTING SAME PROBLEM AFTER CLOSING THE EXCEL SHEET

CAN ANY ONE PLEASE SEND POSSIBLE SOLUTIONS TO THIS PROBLEM

 

[Marco Kalter]

After opening the CSV file, before selecting an Oracle table, do you see the correct columns and data in the "Result Preview" pane on the first tab page?

Also note that your messages will be more readable if you don't use all capitals.

 

[MURALI KRISHNA]

ok thank you macro kaltar

my problem is the fields are not displaying at "configaration area"

and nothing in the "reult preview"

but while saving my excel file as csv(commadelited) file
it shows follwing error
filename.csv may contain more features that are not compatable with csv(comma delimited)do you want work book in this format

we need choose either yes/no/help
while i was saving the file into .csv format

 

[William Robertson]

> but while saving my excel file as csv(commadelited) file
> it shows follwing error
> filename.csv may contain more features that are not compatable with csv(comma delimited)do you want work book in this format

Yes that is how Excel works. Its native format contains fonts, formulas, multiple tabs etc, none of which can be saved in a comma-separated data file. It does however allow the data to be processed by text-based tools such as the PL/SQL Developer Text Importer.

 

[MURALI KRISHNA]

Thanks a lot William Robertson and Macro Kalter for valuble replay