Link to home
Start Free TrialLog in
Avatar of chima
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
SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

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 chima
chima

ASKER

slightwv, I do not know the details now, yet I believe that the data on the Excel files are the known good data.  So I need to compare these known good data with what I find in the database.  I have not worked with SQL Developer, so I do not know what I can do with it.  I am now reading about it.
ASKER CERTIFIED 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
Avatar of chima

ASKER

slightwv and wasimibm, I'll consider your comments.  Please give me time to try them.
Avatar of chima

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
Avatar of chima

ASKER

I do not understand what went wrong, but I hope this works.