Re: Creating Excel file with Jet OLE DB in VB.NET

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: William Ryan eMVP (dotnetguru_at_comcast.nospam.net)
Date: 07/01/04


Date: Thu, 1 Jul 2004 17:35:57 -0400

If you don't have Excel, it's going to be a bear. I'd recommend using
FarPoint's Spread. You can use WriteXML of the dataset to save it as XML
and then open it with Excel in you have XP, but short of that you are going
to have to use a third party tool or write the file format AFAIK.

-- 
W.G. Ryan MVP Windows - Embedded
Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups
"JBAdamsJr" <JBAdamsJr@discussions.microsoft.com> wrote in message
news:F9DC3023-14D2-4A33-9716-5F798A6CCAF8@microsoft.com...
> I want to be able to create an Excel file with a VB.NET program on a
server that does not have Microsoft Excel loaded on it. I am using the Jet
OLE DB to read other data files. Can this be used to save an array in an
Excel .XLS format?


Relevant Pages

  • Re: Benefits of upgrading to Excel2003
    ... You probably don't have access to Excel 2002 and excel 2003 so I've ... Key new features in Microsoft Excel ... Web queries to Extensible Markup Language files. ... If you are not using the specific language version of Microsoft Office ...
    (microsoft.public.excel.misc)
  • Re: Client tools for SQL Server 2005 Analysis Services - Where are they?
    ... "Microsoft also released a Cube add-in for Excel, ... >I have watched webcast after webcast about SQL Server 2005 Business ...
    (microsoft.public.sqlserver.olap)
  • Re: Client tools for SQL Server 2005 Analysis Services - Where are they?
    ... >>I have watched webcast after webcast about SQL Server 2005 Business ... >> touches on their new clients, as well as many other Microsoft Partners ... >> Then there is Excel. ... >> to find that it still costs more to buy the client tools which have ...
    (microsoft.public.sqlserver.olap)
  • Re: Excel 2004 crashes with Right Mouse Button click in OS X 10.4.8
    ... Is your RAM Apple branded, ... Microsoft Office applications? ... I launch Microsoft Excel. ... USB Device: Apple Internal Keyboard / Trackpad, Apple Computer, Up to ...
    (microsoft.public.mac.office.excel)
  • Re: why>?
    ... also; back in the 90s; it might have been a good idea to use Excel. ... Adobe Acrobat and DB2 mainframes-- it is obvious that they need to wake ... Microsoft dug their own hole with regard to antitrust. ...
    (microsoft.public.excel)