Hi,
I have to create excel pivot tables from vb.net. Already I am creating excel
file using oledb connection. I want to use the same to create the excel
pivot tables. Can anyone please help me on this. It is very urgent. Please
reply immediately
Thanks for the help!!!!
nikila
3  8467 
Nikila,
I don't remember me what was a Excel Pivot table. Know that you reach a
small audience with using specific names from other technologies in a
newsgroup, which is not about that technoligy.
However, maybe is this sample on our website your answer. http://www.vb-tips.com/default.aspx?...8-2b9e762316ab
I hope this helps,
Cor
"nikila" <ni*****@yahoo.com> schreef in bericht
news:eD****************@TK2MSFTNGP09.phx.gbl... Hi,
I have to create excel pivot tables from vb.net. Already I am creating
excel file using oledb connection. I want to use the same to create the
excel pivot tables. Can anyone please help me on this. It is very urgent.
Please reply immediately
Thanks for the help!!!!
nikila
Hi,
Thanks for your reply. But I have to generate excel sheet(file) which
has pivot tables
in it from vb.net using oledb
Thanks for help!
Nikila
Cor Ligthert [MVP] wrote: Nikila,
I don't remember me what was a Excel Pivot table. Know that you reach a
small audience with using specific names from other technologies in a
newsgroup, which is not about that technoligy.
However, maybe is this sample on our website your answer.
http://www.vb-tips.com/default.aspx?...8-2b9e762316ab
I hope this helps,
Cor
"nikila" <ni*****@yahoo.com> schreef in bericht
news:eD****************@TK2MSFTNGP09.phx.gbl... Hi,
I have to create excel pivot tables from vb.net. Already I am creating
excel file using oledb connection. I want to use the same to create the
excel pivot tables. Can anyone please help me on this. It is very urgent.
Please reply immediately
Thanks for the help!!!!
nikila
ALso, Is there a way I just use oledb connection instead of
"EXCEL.APPLICATION" etc for creating excel pivot tables in VB.nET.
uses --
"Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=""Excel
8.0;HDR=Yes;"";Data Source="filename"
Final output file is - It is an excel file which has pivot tables and
does not use excel automation"
Thanks for help !
Nikila ni*****@yahoo.com wrote: Hi,
Thanks for your reply. But I have to generate excel sheet(file) which
has pivot tables
in it from vb.net using oledb
Thanks for help!
Nikila
Cor Ligthert [MVP] wrote: Nikila,
I don't remember me what was a Excel Pivot table. Know that you reach a
small audience with using specific names from other technologies in a
newsgroup, which is not about that technoligy.
However, maybe is this sample on our website your answer.
http://www.vb-tips.com/default.aspx?...8-2b9e762316ab
I hope this helps,
Cor
"nikila" <ni*****@yahoo.com> schreef in bericht
news:eD****************@TK2MSFTNGP09.phx.gbl... Hi,
I have to create excel pivot tables from vb.net. Already I am creating
excel file using oledb connection. I want to use the same to create the
excel pivot tables. Can anyone please help me on this. It is very urgent.
Please reply immediately
Thanks for the help!!!!
nikila This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mark Day |
last post by:
Hi All,
I am using Access 2000 to generate over 40 Excel charts and pivot tables
using early binding to the Excel 9.0 object library. I am finding that if I
show the Excel object while processing...
|
by: Johnny Meredith |
last post by:
Dear All,
I have an Access database that tracks the progress of income tax
audits. When the taxing authorities make a change (an "Adjustment"), I
record the pertinent information in the...
|
by: [Yosi] |
last post by:
Can I make an Excel file without having Excel in my PC ?
I want to create Excel files from my C# application , then open those files
later in another PC who have Excel installed .
As we can open...
|
by: Jerome Ranch |
last post by:
I consider myself an Excel PT wizard of sorts, but now I have a
situation with so much infromationthat I need to categorize and
summarize, that I will use access to manage it.
Interestingly,...
|
by: Jerome Ranch |
last post by:
Okay
So I've got pivot tables setup in Access 2003.
Only about 30K records in the current 2005 databases...the pivots
summarize the info in a number of nice ways.
I need to get the pivot tables...
|
by: Decreenisi |
last post by:
Hi,
I have to convert an existing spreadsheet for rejects into an access
database. My problem is I use a load of lookup tabels in excel. How do
I approch this in access. Also, just a general...
|
by: Bill Stock |
last post by:
I'm rebuilding a query for some Excel Pivot Tables, loading the Excel
Workbook and then running a macro in the Excel WB to rebuild the dynamic
column names. This all works, except that sometimes...
|
by: VitorCastro |
last post by:
Hello...
First, sorry for my bad english...
i have generated many pivot tables in Access 2003. and i want the code to export all of them to one single excel sheet and specific cell.
i have...
|
by: DeanL |
last post by:
Hi guys,
I'm fairly fluent in MS Access but I've been handed a task that is
baffling me. I've been asked to produce a report(s) in Excel that has
a series of sales by territory. I have a bunch...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
