INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Unable to insert thru a select

Unable to insert thru a select

(OP)
I have a insert statement in a query in MS ACCESS, the query runs and fetches the data fine but if i use a INSERT INTO TABLE and append it with the query with a select it gives the following error

INSERT INTO statement contains following unknown field name

I have done inserts on other queries and it fails in this query that fetches data,i searched online it says its a bug in Access but there must be a work around

Thanks

RE: Unable to insert thru a select

If you would show us your actual statement,
somebody may be able to help you....

Table definitions of TableA and TableX would be nice, too.

Have fun.

---- Andy

There is a great need for a sarcasm font.

RE: Unable to insert thru a select

(OP)
Table structure is identical

here is the query

INSERT INTO TABLE1
SELECT *
FROM TABLE1_PROD INNER JOIN TABLE2 ON [TABLE1_PROD].HOME_NUMBER=[TABLE2].HOME_NUMBER;

RE: Unable to insert thru a select

I would never perform an INSERT INTO without fully entering the field names. From your SQL it is fairly clear you will have at least two fields with the same name.

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

RE: Unable to insert thru a select

You may try:

... SELECT TABLE1_PROD.*
FROM ...

If that's what you want.

Have fun.

---- Andy

There is a great need for a sarcasm font.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close