mvandhu
10-18-2011, 09:29 AM
Hi All :hi:,
I have an excel workbook with 2 worksheets in it.
Worksheet name : Student, Details
Join Keys are Stu_Id, Name, DOB, Std.
Column names
Student : Stu_Id, Name, DOB, Std, Location
Details : Stu_Id, Name, DOB, Std, Mark1, Mark2, Grade
After join operation is performed, my sheet3 should have the columns as
Stu_Id, Name, DOB, Std, Location, Mark1, Mark2, Grade.
Each time the number of records/row in the 2 worksheets (Student, Details) always varies.
Sometimes the row count may be more than 3000 also.
So need a code that can perform well and takes less time to populate the sheet3 worksheet.
Can someone help me with this scenario....:thumb
Another doubt.
Can SQL query be used in VBA to access the worksheets??
Can the above scenario done using SQL in VBA code??
If so can you post the code for that also???
I have an excel workbook with 2 worksheets in it.
Worksheet name : Student, Details
Join Keys are Stu_Id, Name, DOB, Std.
Column names
Student : Stu_Id, Name, DOB, Std, Location
Details : Stu_Id, Name, DOB, Std, Mark1, Mark2, Grade
After join operation is performed, my sheet3 should have the columns as
Stu_Id, Name, DOB, Std, Location, Mark1, Mark2, Grade.
Each time the number of records/row in the 2 worksheets (Student, Details) always varies.
Sometimes the row count may be more than 3000 also.
So need a code that can perform well and takes less time to populate the sheet3 worksheet.
Can someone help me with this scenario....:thumb
Another doubt.
Can SQL query be used in VBA to access the worksheets??
Can the above scenario done using SQL in VBA code??
If so can you post the code for that also???