By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,946 Members | 773 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,946 IT Pros & Developers. It's quick & easy.

Copying all columns from another table

P: n/a
I am trying to "Copy all columns from another table" here is the SQL
code I am using in MS Access:

CREATE TABLE suppliers
AS (SELECT *
FROM companies
WHERE id 1000);

I think I got it to work once using INTO instead of FROM.

Can you assist me?

Thanks in advance!

John

Mar 13 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Mar 13, 4:37 pm, "jmarr02s" <john.marru...@illinois.govwrote:
I am trying to "Copy all columns from another table" here is the SQL
code I am using in MS Access:

CREATE TABLE suppliers
AS (SELECT *
FROM companies
WHERE id 1000);

I think I got it to work once using INTO instead of FROM.

Can you assist me?

Thanks in advance!

John

Have you tried using the query designer? Even when I don't save the
query I use it to construct the sql for use elsewhere.

Mar 13 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.