Syntax for query-ing MS Excel data

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

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Vladimir Stefanovic Thu, 12 Apr 2007 21:04

#146

Author: Vladimir Stefanovic
Date: Thu, 12 Apr 2007 21:04

20 lines
1268 bytes

Hi,

I have some questions on right syntax for querying MS EXCEL data.

This syntax:
SELECT * FROM [Sheet1$]
...works fine.

But this one:
SELECT * FROM [Sheet1$A1:B3]
...doesn't (I cought an exception in try&catch).

Does anyone know how can I select only sheets in some range
(A1 to B3, for example)



-- 
Best Regards,
Vladimir Stefanovic

Re: Syntax for query-ing MS Excel data

#149

Author: Minas
Date: Mon, 16 Apr 2007 20:30

30 lines
1742 bytes

Vladimir

I think you have to give a name to the range A1:B3 (for example tbl1)
You can do that through Insert->Names Menu in Excel .
That name(range) will be viewed as table . Just format your cells
before apply(give) the name. The cells of the first line will be the
names of the fields

Best Regards

_Minas Harokopos

------
"Only the virtue's conquests have certainty" Sofokleous Erephyle

� "Vladimir Stefanovic" <antivari@po.sbb.co.yu> wrote

>
> I have some questions on right syntax for querying MS EXCEL data.
>
> This syntax:
> SELECT * FROM [Sheet1$]
> ...works fine.
>
> But this one:
> SELECT * FROM [Sheet1$A1:B3]
> ...doesn't (I cought an exception in try&catch).
>
> Does anyone know how can I select only sheets in some range
> (A1 to B3, for example)

Re: Syntax for query-ing MS Excel data

#150

Author: Vladimir Stefanovic
Date: Wed, 18 Apr 2007 19:14

6 lines
954 bytes

Thank you.

-- 
Best Regards,
Vladimir Stefanovic

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads