topic ErrOR : SQL##f - SqlState: 07001, ErrorCode: 4294964286, ErrorMsg: [Microsoft][ODBC Excel Driver] Too few parameters. Expected 1. SQL SELECT * FROM `C:\Users\nikhil.garg\Desktop\Disaster_Data\Copy of Disaster.xlsx`.`Disaster$` WHERE ModificationTime >= in QlikView

ErrOR : SQL##f - SqlState: 07001, ErrorCode: 4294964286, ErrorMsg: [Microsoft][ODBC Excel Driver] Too few parameters. Expected 1. SQL SELECT * FROM `C:\Users\nikhil.garg\Desktop\Disaster_Data\Copy of Disaster.xlsx`.`Disaster$` WHERE ModificationTime >=

nikhilgarg — Fri, 05 Sep 2014 09:52:24 GMT

WHen i am using following code : Following error is there:

My data is in excel sheet which is on local desktop.

Directory;

LOAD Id,

StartDate,

EndDate,

Country,

Type,

Sub_Type,

Name,

Killed,

Injured,

Year

FROM

[Copy of Disaster.xlsx]

(ooxml, embedded labels, table is Disaster);

STORE Disaster into C:\Users\nikhil.garg\Desktop\disaster1.qvd ;

//Connect to odbc and incremental load :

ODBC CONNECT32 TO [Excel Files;DBQ=C:\Users\nikhil.garg\Desktop\Disaster_Data\Copy of Disaster.xlsx] (XUserId is dAHCfQRMNLacWZA, XPassword is QDdXaQRMNLacGMA);

SQL SELECT * FROM `C:\Users\nikhil.garg\Desktop\Disaster_Data\Copy of Disaster.xlsx`.`Disaster$`

WHERE ModificationTime >= #$(LastExecTime)#;

Concatenate

LOAD Id,

StartDate,

EndDate,

Country,

Type,

Sub_Type,

Name,

Killed,

Injured,

Year

FROM

disaster1.qvd

(qvd) WHERE NOT Exists(Id);

STORE Disaster INTO C:\Users\nikhil.garg\Desktop\disaster1.qvd;