Error running SELECT INTO query

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

When I run the below query I get the error 'Table _Temp already exists'. How
can I get past this such that _Temp table gets overwritten if it already
exists?

Thanks

Regards


SELECT INTO _Temp
FROM MyTbl
WHERE ....
 
On Sat, 28 Mar 2009 18:05:54 -0000, "John" <[email protected]>
wrote:

That is not possible. You will have to delete it before running this
statement.
Or, if the structure remains the same, clear out the old data with a
Delete query and fill it with an Append query.

-Tom.
Microsoft Access MVP
 
Back
Top