incremental load - insert only

[arulsettu]

hi

i am trying to do incremental load only in my app.

ODBC CONNECT32 TO [Excel Files;DBQ=C:\Users\Arul\Desktop\my project\CUSTOMERS.xls];

Customer:

SQL SELECT *

FROM `C:\Users\Arul\Desktop\my project\CUSTOMERS.xls`.`CUSTOMERS$`;

STORE Customer into C:\Users\Arul\Desktop\my project\Customer.qvd(qvd);

Customer:

LOAD [Address Number],

  [Business Family],

  [Business Unit],

  Customer,

  [Customer Number],

  [Customer Type],

  Division,

  Phone,

  [Region Code],

  [Regional Sales Mgr],

  [Search Type];

SQL SELECT * FROM `C:\Users\Arul\Desktop\my project\CUSTOMERS.xls`.`CUSTOMERS$`

WHERE [Customer Number] >='10027629'; 

while loading this i am getting error. can anyone help?

thanks...

[its_anandrjs]

What error you get and before full load try to debug the application

[arulsettu]

[its_anandrjs]

Try like Drop the table first

ODBC CONNECT32 TO [Excel Files;DBQ=C:\Users\Arul\Desktop\my project\CUSTOMERS.xls];

Customer:

SQL SELECT *

FROM `C:\Users\Arul\Desktop\my project\CUSTOMERS.xls`.`CUSTOMERS$`;

STORE Customer into C:\Users\Arul\Desktop\my project\Customer.qvd(qvd);

Drop Table Customer;

//And then load the excel file

Customer:

LOAD [Address Number],

  [Business Family],

  [Business Unit],

  Customer,

  [Customer Number],

  [Customer Type],

  Division,

  Phone,

  [Region Code],

  [Regional Sales Mgr],

  [Search Type];

SQL SELECT * FROM `C:\Users\Arul\Desktop\my project\CUSTOMERS.xls`.`CUSTOMERS$`

WHERE [Customer Number] >='10027629';

[tresesco]

Try where clause without quotes like:

WHERE [Customer Number] >=10027629;

[alexandros17]

this is your mistake:

SQL SELECT * FROM `C:\Users\Arul\Desktop\my project\CUSTOMERS.xls`.`CUSTOMERS$`

select is from tables, instead of sql select write load

[its_anandrjs]

In the where condition remove the single quotes (,)

WHERE [Customer Number] >= 10027629;

[arulsettu]

my QVD is getting update without concatenate how?

[#9]

Cause you store select * into your QVD file

[arulsettu]

Hi Thomas

can u elaborate?