Re: Reading Excel Using Jet OleDb

Steven,

Try using "SELECT * FROM [sheet1$]". Do not attempt to replace "sheet1$"
with the name of a sheet. "sheet1$" is the sheet name.

Cheers and good golf,

John Hutton
Northern Systems Inc. (www.northernsystems.com)
Quality Golf Software Products Since 1987
jhutton@xxxxxxxxxxxxxxxxxxxxxxxxxx
Handicap Data :
http://www.ehandicap.net/cgi-bin/hcapstat.exe?CID=nsi&GID=JOHN&SBN=OFF&ACTION=Submit


"yzhao" <yzhao888@xxxxxxxxxxx> wrote in message
news:1140188824.747870.113810@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I understand we can read the Excel using Microsoft Jet OleDb by
providing *** name.

"SELECT * FROM [SheetName$]"

The question is: can we read the active *** in Excel without knowing
the *** name?

Thanks in advance.

Steven



.