Date:         Wed, 7 May 2008 18:29:56 -0400
Reply-To:     Sam Ballard <sballard@SDCCD.EDU>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Sam Ballard <sballard@SDCCD.EDU>
Subject:      Reading Multiple Excel Worksheets

Dear Listserve,

I'm trying to read in three Excel worksheets from the same file all at
once. I keep getting an error and I can't seem to find the problem. I've
tried the wizard too, but I can't get that to work either. The warning
states there is an illegal use of a '.' or '!'. Does anyone know what's
wrong with this syntax?

GET DATA
/TYPE=ODBC
 /CONNECT=
'DSN=Excel Files;DBQ=G:\Shared\SS\From RPNet\2008 Projects\SDUSD Data
Project\Data\fuzzymatchSDCCD.xls;' +
 'DriverId=1046; MaxBufferSize=2048;PageTimeout=5;'
 /SQL =
' SELECT fuzzymatchSDCCD$.  [SSN],  FUZZ'
' FROM  [fuzzymatchSDCCD$], [fuzzymatchSDCCD2$], [fuzzymatchSDCCD3$]'
'  WHERE  [fuzzymatchSDCCD2$]. [SSN] = [fuzzymatchSDCCD$]. [SSN] '
'  AND [fuzzymatchSDCCD3$]. [SSN] = [fuzzymatchSDCCD$]. [SSN] ' .





>Warning.  Command name: GET DATA
>SQLExecDirect failed :[Microsoft][ODBC Excel Driver] Invalid use
of '.', '!', or '()'. in query expression 'fuzzymatchSDCCD$.  [SSN'.


Thanks,
Sam Ballard
SDCCD
sballard@sdccd.edu

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD