SQL: OPENQUERY Question

Question

I am currently using OPENQUERY to import Data into a Database from an Oracle Linked Server.

I am currently using SELECT INTO. It works well, but I have to drop the database and recreate it everytime i need to import the data or else i get the error: Table Already exists.

Is there another way to work with OPENQUERY which will import the data without having to Drop and recreate the table that i need?

Here is what i Have:

SELECT * INTO TEMPTBL FROM OPENQUERY(LINK, 'SELECT * FROM DATALOAD')

Thanks.

drop the table not the database right? – Macy Abbey Dec 13 '10 at 17:45 — Macy Abbey, Dec 13 '10 at 17:45
right, i am having to drop the table after each import – asd Dec 13 '10 at 17:46 — asd, Dec 13 '10 at 17:46

score 1 · Accepted Answer · answered Dec 13 '10 at 19:53

1

Why not this? INSERT INTO PERMTBL (column list) SELECT (column list) FROM OPENQUERY(LINK, 'SELECT (column list) FROM DATALOAD')

answered Dec 13 '10 at 19:53

Andrew S

26
1

SQL: OPENQUERY Question

1 Answers1