#1   Report Post  
Old June 8th 07, 12:27 PM posted to microsoft.public.excel.misc
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?


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
External Data Import MikeD1224 Excel Discussion (Misc queries) 1 February 16th 07 10:22 PM
Import External Data WhytheQ Excel Discussion (Misc queries) 1 January 25th 07 05:51 PM
import external data ana garcia Excel Discussion (Misc queries) 2 April 29th 06 04:05 AM
Import External Data - XML mklapp Excel Discussion (Misc queries) 0 October 26th 05 07:04 PM
Import External Data Susie Excel Worksheet Functions 0 July 29th 05 09:12 PM

All times are GMT +1. The time now is 12:17 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017