H hollyneal Registered User. Local time Today, 05:49 Joined Jan 5, 2012 Messages 21 Jan 19, 2012 #1 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.
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.
pbaldy Wino Moderator Staff member Local time Today, 05:49 Joined Aug 30, 2003 Messages 36,274 Jan 19, 2012 #2 How about an append query: INSERT INTO NewTableName (QuoteNum, Notes) SELECT QuoteNum, Notes FROM OriginalTableName
How about an append query: INSERT INTO NewTableName (QuoteNum, Notes) SELECT QuoteNum, Notes FROM OriginalTableName
H hollyneal Registered User. Local time Today, 05:49 Joined Jan 5, 2012 Messages 21 Jan 19, 2012 #3 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...
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...
H hollyneal Registered User. Local time Today, 05:49 Joined Jan 5, 2012 Messages 21 Jan 19, 2012 #4 Never mind - I figured it out. I can't use the # symbol in my name. Sorry about that...
pbaldy Wino Moderator Staff member Local time Today, 05:49 Joined Aug 30, 2003 Messages 36,274 Jan 19, 2012 #5 Happy to help. You can use symbols, but you shouldn't. Changing it was the right move.