Question for database types..

rogan

rogan

rogan

Associate
Joined
15 Jul 2011
Posts
1,528
Location
London
I have 2 database files from 1 table exported as .xls

one from last year, one from this year with thousands of rows, is there a program of some sort that will give me the rows that are in the new one but not in the old

i.e the difference between the two?

Help appreciated!
 
This is all going way over my head aha. Its for a client we've adopted who are on an old system and they wanted inventory dumps, was hoping there was a simpler way >.<
 
Its not sensetive info its just a list of products youd find on the clients website anyway.

And because im a web dev and they asked for a dump last year and one this year for their accountant, but now theyve recieved this one they 'dont want the whole thing as half of its the same we want the difference'

left to me..!
 
Cheers for the replies guys, the primary key data was totally random because some of it was auto generated and some of it was put in directly

(its for products so it started off well they put in the product id's as tshirt-red but then got lazy and left them so a lot of they are lke 123457) ive sorted it by fobbing them off anyway its their problem really just tried to help if it was a 2 minute job but seemingly not so its for them to sort
 
You must log in or register to reply here.
Back
Top Bottom