MAKE TABLE QUERY mismatch in ROWS!!!

[clueless.really]

1.I import an excel table.
2.I create a query.
3.I make table query.
4.I run the query.
5.The resulting table appeared in the tables tab.

I opened it. It pasted to 0 row when my orig table is 7000 rows!!!
Similar problem: It pasted to 67000 rows when my orig table is 4000 rows!!!

Please help.
I really need this by tomorrow.
I'm new in access 2003 and I don't know any programming!!!

HELP!!!
My boss will fire me if i don't get this right!!!

 

[xenou]

I think you will need to post the queries you are using ... and if possible some sample data - your post suggests three steps (importing data, running a make table query, and querying the table you created) ... any one of these could be the problem, so at this point it's very hard to say. The more exact information you provide the more likely someone can help.

ξ

 

[boblarson]

And I would not be using make table queries. Create the table ONCE and then just delete and append the new data.

Also, as mentioned, you need to post the SQL for the queries (to do that go to the design view of the query and then to VIEW > SQL VIEW. Copy and paste that here.

It sounds like you aren't using table joins properly (or not at all) if you are getting 67,000 rows when the original table is 4,000. It sounds like, what is known as a Cartesian product, where it would give you one row for each combination with another table, or set of tables.