[SOLVED] Datamigrator

May 04, 2011, 11:06 PM

ray_In_Vancouver

How to remove rows while reading Excel ODBC.

I have set up a connection to an Excel sheet using ODBC. The first 2 rows and the last one need to be removed for importing.

Any Ideas. Thanks

This message has been edited. Last edited by: Kerry,

May 05, 2011, 04:32 AM

FrankDutch

I would think of a filter based on the value of the first field.

you can set this in the gui

May 05, 2011, 09:06 AM

ray_In_Vancouver

tried that Filter not working, for some reason.
FILENAME=page1_1$, SUFFIX=SQLODBC , $
SEGMENT=PAGE1_1$, SEGTYPE=S0, $
FIELDNAME=Emp, ALIAS=Title, USAGE=A255V, ACTUAL=A255V,
MISSING=ON, $
FIELDNAME=F2, ALIAS=F2, USAGE=A255V, ACTUAL=A255V,
MISSING=ON, $
FIELDNAME=F3, ALIAS=F3, USAGE=A255V, ACTUAL=A255V,
MISSING=ON, $
FIELDNAME=F4, ALIAS=F4, USAGE=A255V, ACTUAL=A255V,
MISSING=ON, $
FIELDNAME=F5, ALIAS=F5, USAGE=A255V, ACTUAL=A255V,
MISSING=ON, $
FIELDNAME=F6, ALIAS=F6, USAGE=A255V, ACTUAL=A255V,
MISSING=ON, $
FIELDNAME=F7, ALIAS=F7, USAGE=A255V, ACTUAL=A255V,
MISSING=ON, $
FILTER FILTER1=Emp LIKE 'Employee '; $

quote:
Location: MHFE�-�Vineyards AND Employment Status Code: A . . . . . . 0
Employee Number Employee Name (First MI Last Suffix) Employee Name (Last Suffix, First MI) Org Level 3 Code Employment Status Code Location License/Certification Code 0
33112 Paul Bai Paul 0190 A MHFE - Vineyards . 0
33111 Singh Jugnam 0115 A MHFE - Vineyards . 0

May 05, 2011, 06:52 PM

ray_In_Vancouver

Solved

Now how to pass Null instead of Int

	*Frank*
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7