Access-Importing from XL, unable to show all rows of data -Help?

[Guest]

I need fast help while I'm in the office, with Access. I work with an Access
dbase and with several XL reports monthly. I have imported successfully, an
XL file into an Access Table and all of the data appears in the Access table.
There are two queries that nust be run after the file is imported. The first
query makes a New Table "X", which shows the same amount of rows that the
imported file has. The second Query simply runs the table "X", and two other
label tables. Now here is where all of the data is not being pulled in - it's
missing several records! In previous months I've had no problems with running
these queries.
Does anyone know how to resolve this issue?

Thnx!
B

 

[John W. Vinson]

I need fast help while I'm in the office, with Access. I work with an Access
dbase and with several XL reports monthly. I have imported successfully, an
XL file into an Access Table and all of the data appears in the Access table.
There are two queries that nust be run after the file is imported. The first
query makes a New Table "X", which shows the same amount of rows that the
imported file has. The second Query simply runs the table "X", and two other
label tables. Now here is where all of the data is not being pulled in - it's
missing several records! In previous months I've had no problems with running
these queries.
Does anyone know how to resolve this issue?

By correcting the error in the queries.

Since you didn't post any information about the queries or the structure of
the tables, it's more than a bit hard to give advice! Could you open the
offending queries in SQL view and post the SQL text here? My GUESS is that
you're joining the imported table to the "label tables", and there are some
records which have no matching values - but that's just a pure guess.

John W. Vinson [MVP]