select into overwrite table

how can i automatically overwrite an exisitng table when i execute a select
into make table sql statement?

tia,
mcnewsxp

The simplest method would be to include a delete table in the same execution.


--
Wayne
Manchester, England.



"mcnewsxp" wrote:

how can i automatically overwrite an exisitng table when i execute a select
into make table sql statement?

tia,
mcnewsxp

"Wayne-I-M" wrote in message
...
The simplest method would be to include a delete table in the same
execution.


yeah, that's what i ended up doing. thought there might be a way to do it
in one command.




"mcnewsxp" wrote:

how can i automatically overwrite an exisitng table when i execute a
select
into make table sql statement?

tia,
mcnewsxp

If t were me I may be tempted to keep a copy of the old table - just in case

Use DoCmd.CopyObject to rename the table
table1 = rename to table1/date
then use sql make table

or you could just delete the old table right away, maybe its just me I
think. Paranoid about loseing stuff and letting users delete tables without
me looking at the results 1st

:-)


--
Wayne
Manchester, England.



"mcnewsxp" wrote:


"Wayne-I-M" wrote in message
...
The simplest method would be to include a delete table in the same
execution.


yeah, that's what i ended up doing. thought there might be a way to do it
in one command.




"mcnewsxp" wrote:

how can i automatically overwrite an exisitng table when i execute a
select
into make table sql statement?

tia,
mcnewsxp