The first thing I would do is import each worksheet into an access table. Import the first, then import (append) the second. Second I would create a pivot table and set the columns, rows and data accordingly. KM
--- On Wed, 2/11/09, pranav <[email protected]> wrote: From: pranav <[email protected]> Subject: [Access VBA Central] pivot table query... excel To: [email protected] Date: Wednesday, February 11, 2009, 7:06 AM hi... i have problem..... can i create pivot table in access as excel... but i am new in accees... my proble is want to make pivot table using 2 worksheet. i used whole row in 1 sheet excel 2003 i cant use office 2007 because i have register copy of 2003 office.. sheet one have 65536 row data sheet two have 22000 row data i want result from both sheet data in one pivot table... can any one help me... pranav ------------------------------------ Yahoo! Groups Links [Non-text portions of this message have been removed]
