Hi,
WHat is the code to remove all records in SQL Server table w/o deleting structure of the table ?
I tried DoCmd.DeleteObject acTable, "tblSamples_completed" it deletes the table object.
Is Drop TABLE the right syntax in VBA?
ThanksThe safe answer would be:DELETE FROM tblSamples_completedThe quick answer would be:TRUNCATE TABLE tblSamples_completed-PatP
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment