VB reading an excel file
From: Don (Don_at_discussions.microsoft.com)
Date: 09/30/04
- Next message: Gareth Sharp: "Re: ADOBD / JET Transaction Problems"
- Previous message: Norm Cook: "Stored Procedure"
- Messages sorted by: [ date ] [ thread ]
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.
- Next message: Gareth Sharp: "Re: ADOBD / JET Transaction Problems"
- Previous message: Norm Cook: "Stored Procedure"
- Messages sorted by: [ date ] [ thread ]