By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,021 Members | 952 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,021 IT Pros & Developers. It's quick & easy.

comparsion of data in two excel files using vb

P: 1
hi, i am very new to visual basic please guide me how to compare the datas that have been stored in table format in two different excel files using vb.
Aug 29 '08 #1
Share this Question
Share on Google+
1 Reply


Expert Mod 2.5K+
P: 2,545
Hi, and Welcome to Bytes

You don't give us enough detail of what you store in your two Excel sheets to allow us to form an answer for you. Without any idea of what the columns in your two tables are we just can't help you here.

If I was in your position I would link the two Excel tables to Access (use Get External Data, Link Tables to do so), then devise suitable Access queries to join the two tables and compare fields where the rows match.

If you could please provide some more details on what it really is you need I am sure we would be able to help you, but as it stands there is nothing more we can do until we hear from you.

-Stewart
Aug 29 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.