Viewing 4 posts - 1 through 4 (of 4 total)
Rick, Thanks. I need to run this on a MS SQL server, so I did some translating, but can't get past a few things.
Maybe you or someone else can help...
February 2, 2005 at 11:55 am
Ended up going from Excel to a temp table, then using the "Select Where Not" statement from the temp table to the destination table. Could never seem to use the...
December 17, 2003 at 5:46 am
Thanks for all of the input.
I like this idea:
INSERT INTO table
(A, B)
SELECT Excel.A, Excel.B
FROM Excel
WHERE NOT EXISTS
(SELECT 1
FROM table
WHERE Excel.A = Table.A
AND Excel.B = Table.B)
But being a Newbie I am...
December 15, 2003 at 10:16 am
I am using MERGE.
Any hints on what I might be able to use besides hostname? Hostname might work, but I would like to find out what my options are.
Thanks!
...
December 5, 2003 at 5:40 am
Viewing 4 posts - 1 through 4 (of 4 total)