Advanced options in the transform button will offer the option to first remove records in the existing table prior to the import.

I am sort of building a packaged app. The issue is that it still needs to be user friendly, not used by programmers or DBA's.  But it needs to be...

my best solution is still to create a stored procedure that creates this file.  My reason is this.  In this process a cleanup of data is first performed.  Then at...

All processing of monthly data is automated.  Right now the import and export of files is still manual.  And mistakes made delay reporting processing.  So I am trying to automate...

I just found the problem.  I added the delimiters [] to the table name.  It did not like this.  But without them it works fine.

I now find this problem with changing the name.  The filname is altered just fine.  The table structure is fine.  The indexes are lost.  But worse yet the data count...

Thanks Dan, that is exactly what I was looking for.

Then entire process may need to run over.  (sometimes they correct the monthly data after sending reports)  But when I try to use the same syntax you suggested I get...

thanks. that is what I was looking for.  Can't use one table. The idea is scripts recreate all data for the report from the three base tables.  I would need...

Not really what I need to do.  What is needed is to create a complete set of monthly data with the same table names adding the date to the table...

Thanks for a good answer and good directions to be following.

This works (with a few minor field name changes)  issue was [Report 1] table is to be updated,  This report table does not have the storename field.  Report1 (a work...

I would love to see a better way!  This project requires determining 8 different rankings for the Wal-Mart stores.  In this sample, I worked out the updates without nesting cursors. ...

This query takes 15 minutes to execute.  QA works fine.  I have set the connection to 0 and the ODBC timeout to 0... still it's a no go.  The problem...

I am setting the connection time out property.