What does this warning mean? The effect is that data is not read but I don’t understand why. This code worked last week when I had 22 but I
can’t see why that would matter. How is it that the connection was lost? Prior to executing this code I had executed another set of code that accessed another excel file but doesn’t the first two lines define the connection?
Thanks, Gene Maguin
* Encoding: UTF-8.
* M2 FILE.
GET DATA /TYPE=ODBC/CONNECT='DSN=Excel Files;DBQ=U:\Gretchen\AAAF '+
'DatasetM2.xlsx;DriverId=1046;MaxBufferSize=2048;PageTimeout=5;'/
SQL="SELECT `Todays Date` AS Todays_Date, `Phone Number` AS Phone_Number, "+
"`Intake Form Completed (Y/N)` AS Intake_Form_Completed_YN, "+
"Notes FROM `'Call Log$'`"/ASSUMEDSTRWIDTH=1000.
CACHE.
EXECUTE.
Warning. Command name: EXECUTE
SQLFetch (getting tables) failed :[Microsoft][ODBC Excel Driver] The connection for viewing your linked Microsoft Excel worksheet was lost.
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (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
Locked
