VB reading an excel file

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Don (Don_at_discussions.microsoft.com)
Date: 09/30/04


Date: Thu, 30 Sep 2004 08:07:05 -0700

What am I doing wrong (I try to delete all the records on the first excel
*** from myFile.xls):
Public databaseExcel As Database
Set databaseExcel = OpenDatabase("c:\myFile.xls", False, False, "EXCEL 8.0")
databaseExcel.Execute "Delete * from " & databaseExcel.TableDefs(0).Name

I get the error:
Run_time error '3131':
Syntax error in FROM clause.


Quantcast