Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding records from one table into another.

Status
Not open for further replies.
redcare

redcare

Technical User
May 20, 2001
32
0
0
GB
Hi

Iam trying to add records from one table to another using the INSERT Statement.

INSERT INTO Test [Server Name],[Server Location],[Asset Number],
FROM
latest

If anybody Can advise on the correct syntax I would be grateful.

 
Sort by date Sort by votes
Excellent, that worked a treat.
Thanks very much.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
223
Chris Miller
Chris Miller
eboughey1008
  • Locked
  • Question
Import columns from one table into another table with dissimilar field layout
Replies
7
Views
103
Chris Miller
Chris Miller
BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
105
Chris Miller
Chris Miller
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
133
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
Consolidate multiple rows into single row 1
Replies
4
Views
130
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top