chima
asked on
SQL Developer Excel Files
Hello,
I need to compare some Excel spreadsheets with the content in the Oracle database. I'm using SQL Developer. Might you know of a way to automate the comparison of these Excel files. I have not worked with SQL Developer, yet I would think that there is a way of (after query for the identical data), exporting the SQL query via Excel files, then I could compare files against the query files.
Thanks
I need to compare some Excel spreadsheets with the content in the Oracle database. I'm using SQL Developer. Might you know of a way to automate the comparison of these Excel files. I have not worked with SQL Developer, yet I would think that there is a way of (after query for the identical data), exporting the SQL query via Excel files, then I could compare files against the query files.
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
slightwv and wasimibm, I'll consider your comments. Please give me time to try them.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 250 points for wasimibm's comment #a39968444
Assisted answer: 250 points for slightwv's comment #a39968204
Assisted answer: 0 points for chima's comment #a39969765
for the following reason:
thanks
Accepted answer: 250 points for wasimibm's comment #a39968444
Assisted answer: 250 points for slightwv's comment #a39968204
Assisted answer: 0 points for chima's comment #a39969765
for the following reason:
thanks
ASKER
I do not understand what went wrong, but I hope this works.
ASKER