Deleting Rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have never used acess before.

I have a table with 360,000 rows and I want to delete every row except the
first one, how do you do this?

Thanks for your help.
 
Hi Jeff

I have never heard of that one - so I was interested myself.

Try this

Make a copy of your Database (just in case ??)

Copy the table and paste it with a new name
When you paste select "Structure Only"
Open the main table and copy the 1st record
Paste this record into your new table
Delete the first table.
 
Back
Top