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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SV,
My apologies. If none are forthcoming, I do hope you will consider that VBA solution.
Regards,
Patrick
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
You might consider asking "pointer" questions in Oracle and/or Java:
https://www.experts-exchange.com/help.jsp#hi262
Regards,
Patrick
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am looking for a solution in Java or oracle.
regards
sv