Transfer data from one table to another?

hollyneal

Registered User.
Local time
Today, 05:49
Joined
Jan 5, 2012
Messages
21
I've got a database with two fields on it - quote number and notes - that I want to split into its own table. Is there any way to move the data over so I don't have to copy/paste a hundred times?

Many thanks.
 
How about an append query:

INSERT INTO NewTableName (QuoteNum, Notes)
SELECT QuoteNum, Notes
FROM OriginalTableName
 
Thanks! I didn't even think of that. I'm getting a syntax error with it though:

Code:
INSERT INTO QuoteNotes (Quote#, Notes)
SELECT Quote#, Notes
FROM Tracking;

It's in the INSERT INTO part. Any ideas? I looked at the help and it looks like I'm doing it right...
 
Never mind - I figured it out. I can't use the # symbol in my name. Sorry about that...
 
Happy to help. You can use symbols, but you shouldn't. Changing it was the right move.
 

Users who are viewing this thread

Back
Top Bottom