| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA Code to create PIVOT in Excel from access database
I have a CSV file and I wish to create a Pivot out of this.I am
reading CSV to access and then wish to create a pivot from access.I am converting it in to acces so that no of rows do not do not become a limitation in excel . Some body with any idea or VBA code to automate this through VBA ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VBA Code to create PIVOT in Excel from access database
I don't speak access, but I would record a macro when I created the pivottable
manually. With all the variation of data, I think I'd just record a macro when I did it manually. If you want some tips on Pivottable coding, visit Debra Dalgleish's site: http://www.contextures.com/tiptech.html She has lots of stuff under the pivottable section. If you like her site, you may like her book: http://www.amazon.com/gp/product/159...32103?n=283155 ST wrote: I have a CSV file and I wish to create a Pivot out of this.I am reading CSV to access and then wish to create a pivot from access.I am converting it in to acces so that no of rows do not do not become a limitation in excel . Some body with any idea or VBA code to automate this through VBA ? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking access database to an excel file | Excel Discussion (Misc queries) | |||
| Help: pivot chart data in secured Access database wont show fields | Charts and Charting in Excel | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Excel error while trying to import data from an Access database - MSQRY32.exe has generated errors | Excel Discussion (Misc queries) | |||
| Open Access Database under and Excel window using a Macro | Excel Worksheet Functions | |||
Linear Mode
