select into overwrite table

  • Thread starter Thread starter mcnewsxp
  • Start date Start date
M

mcnewsxp

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

tia,
mcnewsxp
 
Wayne-I-M said:
The simplest method would be to include a delete table in the same
execution.
Click to expand...
yeah, that's what i ended up doing. thought there might be a way to do it
in one command.
 
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

:-)
 
Back
Top