Need help on an SQL

[dmaier]

I have a table that needs to have data moved from one with identical fields to another.

I want to move data with an id higher than 75615 to the other table.

The fields are headline, link, team, and Pdate

The idno field is a field which is auto increment. Is there a good way to do this. There are 100 records that I want to move but dont want to copy and re enter.

 

[StevenK]

Hopefully the answer may be as simple as
[If the fields are the same in both table structures]

INSERT INTO [NewTable]
SELECT * FROM [OldTable] WHERE ID > 75615

I hope that this helps.
Steve