Hi,
I'm trying to create a small application to get data from database and export it to excel.
I want to compare input file Excel (one or more columns will be in excel) and compare same columns in database and return matched data and export it to excel.
For example if excel file has Columns: Account,Account Id
Database may have columns : Account,Account Id, Name,Address
process should compare Account and Account ID then return Name and Address for all the records.
Also file may contain huge data (2 to 3Gd ).
Please advise how to compare and extract data to excel.
Regards,
harish