Article View: borland.public.cppbuilder.database.ado
Article #3626Re: Cbuilder4 & Excell97
From: Vassiliev V.V.
Date: Sun, 21 Jul 2002 08:54
Date: Sun, 21 Jul 2002 08:54
38 lines
1978 bytes
1978 bytes
Connect to Access db and execute Select * into NewTable from [Sheet1$] in ""[Excel 8.0;Database=C:\Temp\ExcelFile.xls] NewTable should not exists in Access db. If you need add data to existing table, use Insert into DestTable(Col1, Col2, Col3) Select Col1, Col2, Col3 from [Sheet1$] in ""[Excel 8.0;Database=C:\Temp\ExcelFile.xls] Regards, Vassiliev V.V. http://www.oledbdirect.com "Andre Hayward" <jorhaypi@mweb.co.za> �������/�������� � �������� ���������: news:3d3a3373_1@dnews... > "Shaun" <nospam@nospam.com> wrote: > > >I'll post this answer in case anyone is interested, even if I have answered > >the question myself. > > Hi Shaun, > > Yes, I'm very interested thanks. > > One of the thinks I need to do some time in the future is to upload > Excel spreadsheet data into an Access database. Please advise on the > origin of the "online tutorial". > > Best Regards > > Andre > > >
Technical Details
Message-ID:
<3d3a7900_1@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!mango.news.easynet.net!easynet.net!proxad.net!gatel-ffm!newsfeed01.sul.t-online.de!t-online.de!dnewsReferences:
<3d210c8e$1_2@dnews> <3d39315d_2@dnews> <3d3a3373_1@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,d7212406486d45a7 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-07-21 02:13:42 PST From: "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> Newsgroups: borland.public.cppbuilder.database.ado References: <3d210c8e$1_2@dnews> <3d39315d_2@dnews> <3d3a3373_1@dnews> Subject: Re: Cbuilder4 & Excell97 Date: Sun, 21 Jul 2002 12:54:34 +0400 Lines: 40 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.200 Message-ID: <3d3a7900_1@dnews> X-Trace: dnews 1027242240 62.118.138.200 (21 Jul 2002 02:04:00 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!mango.news.easynet.net!easynet.net!proxad.net!gatel-ffm!newsfeed01.sul.t-online.de!t-online.de!dnews