Article View: borland.public.cppbuilder.database.ado
Article #3490Re: Excel / SQL question
From: Vassiliev V.V.
Date: Sat, 10 Aug 2002 06:35
Date: Sat, 10 Aug 2002 06:35
44 lines
2321 bytes
2321 bytes
It requires Jet provider, Excel itself is not required. Regards, Vassiliev V.V. http://www.oledbdirect.com "Tim" <timsmith_s@yahxxoo.dot.com> �������/�������� � �������� ���������: news:3d5405dd_2@dnews... > Does this require Excel or is it built into the ADO class? > > "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> wrote in message > news:3d5373c8_1@dnews... > > Select * Into [$Sheet1] In ""[Excel 8.0;Database=C:\Temp\MyExcel.xls] From > > MyTable > > > > Regards, > > Vassiliev V.V. > > http://www.oledbdirect.com > > > > "Gareth" <spam@spam.spam> �������/�������� � �������� ���������: > > news:3d528ec5$1_1@dnews... > > > > > > Hi, > > > > > > A couple of weeks ago i found an example of how to insert data from a > > SELECT statement into an excel file (Creating the Excel file at the same > > time). I cannot find this example any more. I know the code went along > the > > lines of > > > > > > SELECT * FROM MyTable INTO MyExcel.xls > > > > > > but there was more to it than that (such as specifying the excel > > version)!. > > > > > > Can someone please post an example of how it should be done? > > > > > > Many thanks, > > > Gareth. > > > > > >
Technical Details
Message-ID:
<3d54b731_1@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.esat.net!skynet.be!skynet.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews!not-for-mailReferences:
<3d528ec5$1_1@dnews> <3d5373c8_1@dnews> <3d5405dd_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,682e3f0560f8986,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-08-10 00:01:31 PST From: "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> Newsgroups: borland.public.cppbuilder.database.ado References: <3d528ec5$1_1@dnews> <3d5373c8_1@dnews> <3d5405dd_2@dnews> Subject: Re: Excel / SQL question Date: Sat, 10 Aug 2002 10:35:41 +0400 Lines: 46 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 62.118.138.196 Message-ID: <3d54b731_1@dnews> X-Trace: dnews 1028962097 62.118.138.196 (9 Aug 2002 23:48:17 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.esat.net!skynet.be!skynet.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews!not-for-mail