hi,

i have to create one Master Data transformation tool use Microsoft access. The input file and output file of this tool are excel spreadsheet. There are 2 levels of the data transformation, first level is data mapping and validation on the raw data, second level is data update on the field value.

My question can someone show me step by step how to build this tools using access and read from excell.

*UGH*
Is this one of those questions:
Please make what I need??

You pretty much give the steps yourself
1) Import spreadsheet
Docmd.transferspreadsheet seems to suffice?
2) Validate
Do some query stuff to make sure things look right
3) Export
Do some queries/code to export the data.

mmm... so first i would need to know how i want to select source file from excell. let say i design the view form. what tools that i want to select? to choose file from excell...

thanks

Have a search for "File picker" and you should find some samples