did you run the identical query in Access - did it return 700 records.

--
Regards,
Tom Ogilvy


"Kirsti" wrote in message
...
I'm importing multiple, linked tables from an access database. All the
tables
are coming into Excel and showing as the correct field names, but half of
my
records are missing. I'm expecting over 700 and there are only just over
300.
Hope this makes sense, i'm a newby!
kirsti