empty a table/delete all records

[Jen0dorf]

Hi



working ona table and realised I made a fundemental error.

I've imported 3000 records in error

Is there an easy way to delete these records other than delete the table and start again?

A google search suggests vba etc etc

thanks

Ian

[cyanidem]

Manually - open a table, click its left top corner (with an arrow) and press Delete.
VBA - DoCmd.RunSQL "DELETE * from TableName"

[orange]

Did you try a delete query?

DELETE *
FROM YourTableNameGoesHere;

[Jen0dorf]

Hi

yes I did but I got the syntax totaly wrong hence it threw up an error
for some reason I had

DELETE tbl_Marriage.*
FROM tbl_Marriage;

Whereas your code worked perfectly

thanks

Ian