PDA

Click to See Complete Forum and Search --> : clearing an Access table from VB


valvoj
Jul 28th, 1999, 06:43 PM
Hi,
I'm writing data from a flexgrid to a table in Access 97. There may already be data in the table. How can I clear all the data in the table every time I write to it?

Thanks,
Jason

kishore
Jul 28th, 1999, 07:51 PM
You can delete all the data from table


Dim Db as database
Dim SQLs as string
Set db = opendatabase("C:\Bibilio.mdb")
SQLs= "Delete from Address"
Db.execute SQLS

The above SQL command will delete all the contents from the table Address


I hope this is what you want

valvoj
Jul 28th, 1999, 09:11 PM
Thanks!

Works just fine