select into overwrite table

M

mcnewsxp

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

tia,
mcnewsxp
 
M

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.
 
W

Wayne-I-M

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

:)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import from ms access table name unknown 1
search and replace query for a value in every column 5
add new record from linked table 9
make table query corrupts hyperlink field 15
data merge 0
select combobox item 7
what kind of query? 1
execute subroutine on subform 4

Top