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]

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;