Re: Copying Excel Sheet to Access mdb as Table

Article View: borland.public.cppbuilder.database.ado

Article #1285

Back to borland.public.cppbuilder.database.ado Previous Next

#1285

From: uchan
Date: Tue, 14 Sep 2004 13:25

30 lines
1605 bytes

"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message 
news:4146b03c@newsgroups.borland.com...
> SELECT * INTO Sheet1 FROM [Sheet1$] IN "" [Excel 8.0;Database=test.xls]




I tried but still got OleException error !

Says ParameterObject is not correctly defined

What should i do?



I arrange my last code as follows:



 ADOCommand2->CommandText =

                    "SELECT * INTO data2 IN 'd:\\zwork2.mdb' FROM [Sheet1$] 
IN  [Excel 8.0;Database=d:\test.xls]";

 ADOCommand2->Execute();



Help me please

Technical Details

Message-ID: <4146f15a$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

References: <41465b3c@newsgroups.borland.com> <4146b03c@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,554dceaed0ee4c4e
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "uchan" <usami_takeshi@yahoo.co.jp>
Newsgroups: borland.public.cppbuilder.database.ado
References: <41465b3c@newsgroups.borland.com> <4146b03c@newsgroups.borland.com>
Subject: Re: Copying  Excel Sheet to Access mdb as Table
Date: Tue, 14 Sep 2004 22:25:41 +0900
Lines: 32
MIME-Version: 1.0
Content-Type: text/plain;
 format=flowed;
 charset="iso-2022-jp";
 reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: 220.29.54.69
Message-ID: <4146f15a$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1095168346 220.29.54.69 (14 Sep 2004 06:25:46 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Reply to Parent Message