Re: Appending workbooks
Thanks for your reply Alan and Youtham.. Let me answer Alan First..
1. Each file contains around 1000 records.
2. I am Sorry I can't answer ur 2 nd question it is hard to tell. Actually each file contains 25 columns and I need to append only 10 columns which is common in all the files.. Just to explain u with an eg I told u that it has 5 columns and need to append those 3 common (emp name, emp email & amount).
3. Yes all the field names which I need to append are definelty the same in each files
and I know Access basic, I can make a table, link a table..but don't know to write queries..(I am at the learning stage) I appologize..
I am sorry, I would like to send the sample file but it is so large to send it...
Eagerly waiting for a solution.
Thanks in advance