Article View: borland.public.cppbuilder.database.ado
Article #2753Re: Exporting Data
From: Viatcheslav V. Vassiliev
Date: Sun, 30 Mar 2003 08:30
Date: Sun, 30 Mar 2003 08:30
22 lines
2014 bytes
2014 bytes
You can do this manually - with TADOConnection (ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Temp\\MyFile.xls;Extended properties=Excel 8.0), create new sheet with CREATE TABLE and insert rows one-by-one. You can also use SELECT .. INTO SQL statement if your DBMS support exporting into other DBMS. Look help for SELECT INTO in your DBMS help files. ---------------------------------------------------------------- Regards, Viatcheslav V. Vassiliev http://www.oledbdirect.com The fastest way to access MS SQL Server, MS Jet (MS Access) and Interbase (through OLEDB) databases. "Wilber G." <00573330@conestogac.on.ca> �������/�������� � �������� ���������: news:3e860cba@newsgroups.borland.com... > Hi , I need to export data from an sql query (dataset) or from a DBGrid to > excel. Can anyone please help? > >
Technical Details
Message-ID:
<3e86abbf@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer2.atl.newshosting.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3e860cba@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,9e1d1c2d75dff5cf X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-03-30 00:38:47 PST From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3e860cba@newsgroups.borland.com> Subject: Re: Exporting Data Date: Sun, 30 Mar 2003 12:30:56 +0400 Lines: 24 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 NNTP-Posting-Host: 213.247.201.57 Message-ID: <3e86abbf@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1049013183 213.247.201.57 (30 Mar 2003 00:33:03 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer2.atl.newshosting.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail