Import Excel spreadsheet into Oracle 1

[WDInc]

I have an excel spread sheet with names and numbers can I import it into oracle?

Thanks

 

[Scunningham99]

create a csv file and use sql loader to upload file in to oracle table

sy

 

[jmoscari]

There are 2 options one is using sql loader or if it is related to the General Ledger or Fixed Assets you could use ADI if it is installed on your desktop.
I would need more information as to what you are importing and where you want it to go.

 

[kpearson]

Another option would be to use a tool called Dataloader available at

http://www.comstar.co.uk/dataload/

. This tool allows you to use the Oracle Applications Forms to mimic the data entry. It really depends if you are trying to save data entry keystrokes or just loading data directly to the table level which then you would use SQL Loader.

 

[ninelaz]

try ,a macro stuff.

 

[kacampbell]

What do you recommend for Supplier upload? SQL Loader or Dataloader?