| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import from Access to Excel, via pivot table
the pivot table will operate happily on more than 64k rows but you will have to change from storing the underlying data in the excel worksheet. see pivot table wizard, step 1 of 3, and select external data source. Alternatively extract the source data into a text file in csv or tab delimited format (or another database) and attach to that as external data if you want to keep a copy of the data locally on your machine for some reason. regards.. -- steven1001 ------------------------------------------------------------------------ steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757 View this thread: http://www.excelforum.com/showthread...hreadid=522194 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Large Access Table into Excel | Links and Linking in Excel | |||
| create pivot table from excel table | Excel Worksheet Functions | |||
| Pivot Table Memory Issue - Excel crashes | Excel Discussion (Misc queries) | |||
| Excel Pivot Table with Access | Excel Discussion (Misc queries) | |||
| Can links between Excel 2003 Pivot Charts and their pivot table b. | Charts and Charting in Excel | |||
Threaded Mode
