Phil Parkin (3/6/2013)
Cool - is it an ascending number?The reason I ask: one way to do this would be to query your existing data, get max(id) and then get the new data by selecting from it where id > maxid.
By the way, what happens if changes to existing data occur - don't you want to update that too?
Yes, ascending number. It is auto generated by the system, and customers are never deleted. In this case I'm only interested in appending the data.