To convert an Excel file to CSV and then move that data from CSV to oracle database.
-
Hi all, I have one task , To convert an Excel file to CSV and then move that data from CSV to oracle database. EXCEL FILE HAS :3 COLUMNS NAME,CITY,STATE . my requirement is I need to convert from excel to csv and csv to oracle datatable I have to do in backend. asked me to use sqlloader. earlier I haven't worked on this type of ticket. can you please give me an idea . I have to do in backend not in .net application. I am using ORACLE(TOAD) What I have tried: Hi all, I have one task , To convert an Excel file to CSV and then move that data from CSV to oracle database. EXCEL FILE HAS :3 COLUMNS NAME,CITY,STATE . my requirement is I need to convert from excel to csv and csv to oracle datatable I have to do sqlloader . earlier I haven't worked on this type of ticket. can you please give me an idea . I have to do in backend not in .net application. I am using PLSQL(TOAD)
-
Hi all, I have one task , To convert an Excel file to CSV and then move that data from CSV to oracle database. EXCEL FILE HAS :3 COLUMNS NAME,CITY,STATE . my requirement is I need to convert from excel to csv and csv to oracle datatable I have to do in backend. asked me to use sqlloader. earlier I haven't worked on this type of ticket. can you please give me an idea . I have to do in backend not in .net application. I am using ORACLE(TOAD) What I have tried: Hi all, I have one task , To convert an Excel file to CSV and then move that data from CSV to oracle database. EXCEL FILE HAS :3 COLUMNS NAME,CITY,STATE . my requirement is I need to convert from excel to csv and csv to oracle datatable I have to do sqlloader . earlier I haven't worked on this type of ticket. can you please give me an idea . I have to do in backend not in .net application. I am using PLSQL(TOAD)
If it is one time... 1. You can save the file as CSV. Do a "save as" and then pick the 'type' via the drop down. 2. Then as noted you can use sqlloader. If you must automate this to do it over and over then there are other problems you did not touch on like how you know there is a new file and how to recognize an update versus new. But at any rate it is possible to read an excel file via an "ODBC" driver. I believe this is still possible, once you track down the driver. This would with very simple Excel files.
-
Hi all, I have one task , To convert an Excel file to CSV and then move that data from CSV to oracle database. EXCEL FILE HAS :3 COLUMNS NAME,CITY,STATE . my requirement is I need to convert from excel to csv and csv to oracle datatable I have to do in backend. asked me to use sqlloader. earlier I haven't worked on this type of ticket. can you please give me an idea . I have to do in backend not in .net application. I am using ORACLE(TOAD) What I have tried: Hi all, I have one task , To convert an Excel file to CSV and then move that data from CSV to oracle database. EXCEL FILE HAS :3 COLUMNS NAME,CITY,STATE . my requirement is I need to convert from excel to csv and csv to oracle datatable I have to do sqlloader . earlier I haven't worked on this type of ticket. can you please give me an idea . I have to do in backend not in .net application. I am using PLSQL(TOAD)