Losing rows of data when making a table

[jmaziggy]

Hello all,

I am new to Access and I have encountered a problem that I can't seem to solve. I have imported 3 different excel worksheets into Access. I then created a query in which I made some relationships and select the fields that I need to make a new table. The problem is, when I run the table the final product is missing about 20,000 rows of data. I have used this protocol successfully for other other files, but for some reason, with this dataset Access is pasting 10,000 rows into the new table, where the original file has 39,000. I've searched the internet but I have not been able to find anyone with the same problem. I would greatly appreciate any input here.

Thanks!

 

[Beetle]

There's not really enough information in your post to answer the question. It could be import errors (i.e. a Data Type mismatch or something). It could be the joins in your query that are excluding records from the original data set. It could be something else.

Are you getting any error messages?

How many records does your query return?