Data Reconcilation Tool

[balamurugan.r]

Hi guys,



i new to MsAccess VBA programming.. I have got requirement having mulitple input files with various columns . I want to write some validation rules for each columns/files and to retrieve the total count of records in each file as part of reconcilation.. can you please help me how to start with this requirement..this is very urgent.. thanks in advance.


Regards
r

[drunkenneo]

I would suggest first analyse the input you get and on basis validations can b possible. by ur statement i could only suggest you this.

[balamurugan.r]

I have one excel sheet which contains few columns might be same as columns in one of the ms access table.. i need to reconciliate the data in both excel sheet & ms access table and have to generate the report for non matching columns & cells... Do you have sample project of this requirement. It will be helpful for me to proceed.. Thanks in Advance