I'm wondering if you ever figured out what the problem was. Interestingly enough, I'm also encountering the same problem trying to run a batch file with WinSCP. I can run...

Thanks! This is what I need to know.. all of options available to me. I'm gonna check even option 2 because if it's relatively fast to do this, this might...

Just to let you know that this has been a real help for me. I was looking to eliminate duplicates with different timestamp and I got stuck for a while...

Admin rights, yes.

I'm doing a clean install on a new box. I wonder if doing an upgrade is easier.

The problem is I still can't install the database service, so I can't connect to a local database.

Thanks for the reply and the books recommendation. I finally found it from other forum.

Just for other newbies like me, the SQL command is:

INSERT INTO tblName1 (Column1, Column2)

SELECT Column1, Column2

FROM...