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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting into excel 3
Convert acess table to csv file 1
Convert to csv 1
Does access 2000 pivot table have a limit on rows 6
Sort more then 65,000 rows in Excel 2
Turn off prompts that alert 2
Delete rows in different tables 7
Excel Help to copy information from one row at a time to another sheet 1

Back
Top