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
 
The simplest method would be to include a delete table in the same execution.
 
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

:-)
 
You must log in or register to reply here.

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
make table query corrupts hyperlink field 15
add new record from linked table 9
data merge 0
fill datagridview from sql 1
select combobox item 7
anybody having trouble with reports? 1

Back
Top