I'm trying to save data to a temp table. I'd like all existing data in the
temp table to be cleared before the new data inserted. How can I do that
using SQL?
Thanks in a advance.

Samantha wrote:
> I'm trying to save data to a temp table. I'd like all existing data
> in the temp table to be cleared before the new data inserted. How
> can I do that using SQL?
> Thanks in a advance.

DELETE TableName.* FROM TableName

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Hi, Samantha.

> I'd like all existing data in the
> temp table to be cleared before the new data inserted. How can I do that
> using SQL?

Try:

DELETE *
FROM TempTable;

Be aware of database bloat, though. Make sure that the database is
compacted frequently after deleting many records in tables.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.


"Samantha" wrote:

> I'm trying to save data to a temp table. I'd like all existing data in the
> temp table to be cleared before the new data inserted. How can I do that
> using SQL?
> Thanks in a advance.
>

DELETE * FROM tblTempData;

Samantha wrote:
> I'm trying to save data to a temp table. I'd like all existing data in the
> temp table to be cleared before the new data inserted. How can I do that
> using SQL?
> Thanks in a advance.
>

True, if I'm not mistaken though there is a way to compact a database
via code. I've never done it so I'd have to dig into help. I believe
that the syntax is CurrentDatabase.Compact but NOT certain.

'69 Camaro wrote:
> Hi, Samantha.
>
>
>>I'd like all existing data in the
>>temp table to be cleared before the new data inserted. How can I do that
>>using SQL?
>
>
> Try:
>
> DELETE *
> FROM TempTable;
>
> Be aware of database bloat, though. Make sure that the database is
> compacted frequently after deleting many records in tables.
>
> HTH.
>
> Gunny
>
> See http://www.QBuilt.com for all your database needs.
> See http://www.Access.QBuilt.com for Microsoft Access tips.
>
> (Please remove ZERO_SPAM from my reply E-mail address, so that a message
> will be forwarded to me.)
>
> - - -
> When you see correct answers to your question posted in Microsoft's Online
> Community, please sign in to the Community and mark these posts as "Answers,"
> so that all may benefit by filtering on "Answered questions" and quickly
> finding the right answers to similar questions. (Only "Answers" have green
> check-marks.) Remember that the best answers are often given to those who
> have a history of rewarding the contributors who have taken the time to
> answer questions correctly.
>
>
> "Samantha" wrote:
>
>
>>I'm trying to save data to a temp table. I'd like all existing data in the
>>temp table to be cleared before the new data inserted. How can I do that
>>using SQL?
>>Thanks in a advance.
>>

"David C. Holley" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)
> True, if I'm not mistaken though there is a way to compact a database
> via code. I've never done it so I'd have to dig into help. I believe
> that the syntax is CurrentDatabase.Compact but NOT certain.

Not exactly. It's complicated, if you're using Access 97; easy if
you're using Access 2000 or later. See this link:

http://www.mvps.org/access/general/gen0013.htm
Why CompactCurrentDatabase doesn't work from code

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Thanks everyone. I'll have to check into the compact issue since it looks
complicated.

"Samantha" wrote:

> I'm trying to save data to a temp table. I'd like all existing data in the
> temp table to be cleared before the new data inserted. How can I do that
> using SQL?
> Thanks in a advance.
>