Truncate MS Access Table from Visual Studio using SQL code

• Howard C. BAchtel-438731

  SSCrazy

  Points: 2384

  More actions

  December 24, 2014 at 9:19 am

  #299797

  I am building a Visual Sudio process that will Truncate and load data to an Access database (2010) from SQL Server (2012). I have one "Execute SQL Task" for one table (LungCancer_HF_Patients):

  "DELETE LungCancer_HF_Patients.* FROM LungCancer_HF_Patients;" that parses and works.

  I have another table (Report1):

  "DELETE Report1.* FROM Report1;"

  that does not parse with a message "The query failed to parse. Incorrect syntax near '*'."

  Can anyone tell me why the first one parses correctly and the other one does not?

  Any help is greatly appreciated.

  Thank you.

• pietlinden

  SSC Guru

  Points: 63591

  More actions

  December 24, 2014 at 9:55 am

  #1766361

  The only thing I can think of is that you have another object named "Report1" in the database. Otherwise it should work.

• Howard C. BAchtel-438731

  SSCrazy

  Points: 2384

  More actions

  December 29, 2014 at 6:00 am

  #1766744

  Thank you. I found the problem and there was a typo in the table name.