Hi Bob
I thought about it, and here it is.
I have an excel file, with an odd 60.000 records. Then, I have a MySQL DB
with 24000 records. Now, those 24000 records also appear in the .xls file.
Thus, I only want to upload the "new" records. I have an MSSQL 2000 DB as
well, and though I'd use that to do the database sorting, but then it would
need to be exported again.
Unless there is a way of importing all the stuff. When it comes to a record
that already exists, to simply skip it, and go on with the next one?
--
Kind Regards
Rudi Ahlers
+27 (82) 926 1689
Greater love has no one than this, that he lay down his life for his friends
(John 15:13).
"Bob Barrows" <re******@NOyahoo.SPAMcom> wrote in message
news:ed**************@tk2msftngp13.phx.gbl...
Rudi Ahlers wrote:
A different question though. Is it possible to delete duplicate
entries, where the email address is the same, and only keep one?
i.e..
I got say 4 DB entries, all with the same email address, and I want to
delete 3. How do I do this?
What database please? Type and version.
Oh, and a little more information about the table structure would be
helpful. How do you want to decide which record to keep, and which ones to
discard?
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"