Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
only a portion of my data is being imported to excel from access
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
only a portion of my data is being imported to excel from access
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
only a portion of my data is being imported to excel from acce
Hi Tom, I just ran the identical query in Excel and Access and both are
bringing up the same info, the query should be bringing in all records showing only a few specific fields but it's now showing only 632 of 721 records. This is not a parameter query and has no criteria listed. Thanks, Kirsti "Tom Ogilvy" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
only a portion of my data is being imported to excel from acce
I don't know - I wouldn't expect them to be different if the query is the
same. -- Regards, Tom Ogilvy "Kirsti" wrote in message ... Hi Tom, I just ran the identical query in Excel and Access and both are bringing up the same info, the query should be bringing in all records showing only a few specific fields but it's now showing only 632 of 721 records. This is not a parameter query and has no criteria listed. Thanks, Kirsti "Tom Ogilvy" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I fit a line on an excel plot to a portion of the data? | Charts and Charting in Excel | |||
How do I set up an Excel file to be imported into Access | Excel Discussion (Misc queries) | |||
How to convert imported Access Hyperlinks to Excel and KEEP the li | Excel Worksheet Functions | |||
My formulas can't 'see' numbers imported from Access in Excel, even when the format is the same. | Excel Discussion (Misc queries) | |||
Limiting Data Imported from Access to Excel | Excel Programming |