Re: An efficient way to read data from excel


"McKirahan" <News@xxxxxxxxxxxxx> wrote in message
news:NfqdnWdIQKHhqo3anZ2dnUVZ_tajnZ2d@xxxxxxxxxxxxxx
"Paul Randall" <paulr901@xxxxxxxxxxxx> wrote in message
news:O$l3IOTDIHA.536@xxxxxxxxxxxxxxxxxxxxxxx

"McKirahan" <News@xxxxxxxxxxxxx> wrote in message
news:1LSdnfmuSPrvZJLanZ2dnUVZ_jidnZ2d@xxxxxxxxxxxxxx
"Paul Randall" <paulr901@xxxxxxxxxxxx> wrote in message
news:em9f#wPDIHA.2004@xxxxxxxxxxxxxxxxxxxxxxx

[snip]

[snip]

Hi, McKirahan

Do you have some URLs for SQL documentation specific to this task?

The "specific task" my script solves is for the post by "FaisalVali"
that asked: "I am trying to use jscript to read ... an excel
spread***.".

I'm not sure I know enough about SQL to ask an intelligent question.

In your sample script, the following three lines are key to getting the
data:

< var cXLS = "MS_Excel.xls";
< var cDRV = "DRIVER=Microsoft Excel Driver (*.xls);DBQ=";
< oRST.Open("SELECT * FROM [Sheet1$]", cDRV + cXLS);

It seems to me that this select statement might not be correct if cDRV
used
an access database or text file driver, since they don't have worksheets.

Duh!

Does the $ symbol signify that this is a *** number and not the name of
a
***? Must you leave the $ out if you put the actual *** name between
the square brackets?

So maybe my question should be: Do you have some URLs for SQL
documentation
that applies to each of the ODBC drivers listed in in the ODBC Data
Source
Administrator Drivers tab on my computer?

Or maybe the question should be: knowing that I have some specific ODBC
driver, like Microsoft Paradox Driver Version 4.00.6340.00, how do I go
about finding documentation for SQL statements I might want to apply
through
this driver to some Paradox database file?

-Paul Randall

Are you trying to start a new thread with your questions?
If so then please post with an applicable subject line.

Actually, I thought the original poster might like a reference manual on how
to extract the various parts of the spread***, or maybe the exact info the
OP asked for - namely column one. I guess I broadened the question too
much, asking on how to find the reference manual on how to extract data
through any of the ODBC drivers that can be used with Ado.

-Paul Randall


.