Link to home
Start Free TrialLog in
Avatar of svanukuri
svanukuri

asked on

Excel to CSV

Hi All,
I have an excel spreadsheet with multiple tabs . I want to read the data in this spreadsheet using external tables in oracle 9i which is working fine. My problem is I need to save each tab as a csv which is not acceptable. The requirement is to convert the spreadsheet tabs into csv files programatically.
Can anyone help me with this please.  

regards
SV
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of svanukuri
svanukuri

ASKER

Thanks Patrick ,
I am looking for a solution in Java or oracle.

regards
sv
SV,

My apologies.  If none are forthcoming, I do hope you will consider that VBA solution.

Regards,

Patrick
sv,

You might consider asking "pointer" questions in Oracle and/or Java:

https://www.experts-exchange.com/help.jsp#hi262

Regards,

Patrick
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial