how to truncate a table in Access

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rockitman <Rockitman@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 20 Nov 2008 15:28:01 -0800

I'm creating a local package in a 2000 SQL server that FTP's a flat file,
transforms this data to a table in an Access database, then transforms this
table to a table on the SQL server. We use the Access database for other
things, so don't ask why I'm not just moving the data straight to the SQL
table.
My problem is that unless I put out a clean Access file in the desired
directory (by clean, I mean that the table in it is blank) before this
package runs, it will error out because it will see duplicate entries in the
table.

So, how can I clear the contents of this Access table first, using this
local package?
Which task will do this? Is it possible?
.

Follow-Ups:
- Re: how to truncate a table in Access
  - From: Gerald Aichholzer

Prev by Date: Re: DTS Failed when Sheduled
Next by Date: help with script
Previous by thread: SSIS - one xml configuration file for multiple packages
Next by thread: Re: how to truncate a table in Access
Index(es):
- Date
- Thread

Relevant Pages

Re: how to truncate a table in Access
... transforms this data to a table in an Access database, then transforms this table to a table on the SQL server. ... We use the Access database for other things, so don't ask why I'm not just moving the data straight to the SQL table. ... So, how can I clear the contents of this Access table first, using this local package? ...
(microsoft.public.sqlserver.dts)
Re: tool to re-reference forms after usizing?
... Speed Ferret (which I hate to admit that I've never been able to get to ... tblCustomerAddress, remember that changing tblCustomer to something else ... >>> I am in the process of upsizing an access database to sql server. ...
(microsoft.public.access.conversion)
Re: ODBC parameters and system resources
... Install MSDE or use an existing SQL Server. ... I connect to an Access database of about 500MB in size. ... there is the "Not enough space on temporary disk". ... What can a "System resource" be apart from disk space and RAM? ...
(comp.databases.ms-access)
Re: Migrating away from MS-Access
... Ive just stepped into a role to migrate an access database to VB.Net. ... At some stage we have to migrate the access backend to SQL Server. ... A dot-net front end with an MDB file back end is the worst of all worlds. ...
(comp.databases.ms-access)
RE: ODBCDirect Workspace
... successfully ported my tables to SQL Server and have created an Access ... Are you using one Access database to work inside of another Access database? ... Dim strSql As String ... However if you are going to be using this query again to populate the combo ...
(microsoft.public.access.modulesdaovba)