clearing an Access table from VB

[valvoj]

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]

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]

Thanks!

Works just fine