Clear Table Query??

hhanson

Board Regular
Joined
Mar 23, 2005
Messages
73
Is there a way to set up a query that will clear a table. I know I can
make a query the "makes" a table and if the table already exsist then it
deletes all the data in it. However, this also deletes the formats of the
table, such as "Index: NO, no duplicates". Is there a way to get around this?
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,061
Office Version
  1. 365
Platform
  1. Windows
What are you doing that gets rid of the 'formats'?

Why not just copy the table then paste only the structure?

Or use a DELETE query.
 

hhanson

Board Regular
Joined
Mar 23, 2005
Messages
73
Thanks

The delete query works like a charm... that was too easy...
Thanks for pointing out the obvious.

Thanks,
Howie
 

Watch MrExcel Video

Forum statistics

Threads
1,118,820
Messages
5,574,508
Members
412,599
Latest member
Schu94
Top