how to delete imported data from sheet in VBA

Hi I am trying to clear the imported data in a sheet using VBA. I have tried using:

Sub test()

Sheet2.Cells.ClearContents


End Sub

but excel still sees the imported data and I can only edit it instead of being able to import new data.
Any ideas on how to delete it with a macro?

Thanks,
Brad