I have a access table with 43 column and approx 370.000 records.
Not all colunmn are fille with value.
How to delete all records with ado jet + VB6 and query with a fasted method???
delete a lot records in acces table with ado
-
sal21
- PlatinumLounger
- Posts: 4347
- Joined: 26 Apr 2010, 17:36
-
HansV
- Administrator
- Posts: 78405
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: delete a lot records in acces table with ado
Welcome to Eileen's Lounge.
To delete all records from a table in a Jet database, you can use the following SQL statement:
DELETE * FROM [TableName]
where TableName is the name of the table.
To delete all records from a table in a Jet database, you can use the following SQL statement:
DELETE * FROM [TableName]
where TableName is the name of the table.
Best wishes,
Hans
Hans