View Single Post
  #1   Report Post  
Old June 8th 07, 12:27 PM posted to microsoft.public.excel.misc
Willow Willow is offline
external usenet poster
First recorded activity by ExcelBanter: Jun 2007
Posts: 2
Default Import External Data

I'm trying to set up data imports from an Access Database into Excel
using the Import External Data function.

This works fine for some queries, which are pulling into Exce fully,
other queries are only bringing across column headings without any of
the data and one query is pulling two rows, from an Access query which
contains four rows but is adding the values of the two rows it is not
importing to one of the rows that is e.g

The access query contains two columns - Where now? and Count of
Service. The values in these columns are Community, Deceased, Other
and Permanent and 9, 4, 7 and 2 respectively.

When the data is pulled into Excel, it is only pulling the Deceased
(which shows the correct count of 4) and Other which shows a count of
18 i.e. the total of the Other, Community and Permanent rows.

I am not getting any error messages.

Does anyone know why this is happening and what can be done to fix it?