Does INTO statement delete existing table?

[vetabz]

Do I have to issue a DROP TABLE before I do a SELECT-INTO combination? or can I do a SELECT-INTO knowing that it will delete the existing destination table?

I'm doing this for backup purposes or on temporary tables.

[ranman256]

Is this an SQL Server (or Oracle) question?
Access doesnt have drop table, nor select into,

empty a table with a delete query.
append query uses INSERT INTO

[pbaldy]

Access doesnt have drop table, nor select into,

Say what? Access supports DDL queries, which is what the first is, and the second is a make table query, which Access supports.

Seems like it would have been easy to test, but in my experience Access replaces the table.

[vetabz]

Hmmm... can please take a look at this sample database... basically I just want to make sure that SELECT-INTO deletes the table or the data in it prior to loading the data.

I'm not sure what you mean by the in-availability of the functions I mentioned because it's there.

Drop_SelectInto.zip

[vetabz]

Seems like it would have been easy to test, but in my experience Access replaces the table.

This is my guess as well, and it seems like it after testing. I basically just wanted to confirm that it is so...

[pbaldy]

Just tested and confirmed. Just put something different into source and run the query again.

[pbaldy]

I should have added that as a rule, I'd empty/repopulate as ranman suggested rather than make table.