Pivot Table

From: jules (julian_at_saix.net)
Date: 01/03/05 

Date: Mon, 3 Jan 2005 21:12:48 +0200

Hi

I'm using Excel 2000 and am trying access a MS 2000 access database via a
pivot table. When I link to the database using the "Get Data" option I can
see all the table and queries but cannot see the fields. However when I
convert the database to a previous version and use Excel 97 I have no
problems in accessing all the data and queries. Any ideas.

Thanks
Julian

Relevant Pages

  • Re: Access and Excel
    ... via append queries and update queries. ... > Excel spreadsheets. ... > wanting to create some sort of Access database for her as ...
    (microsoft.public.access.tablesdbdesign)
  • Re: office 2003 Word mailmerge with Access
    ... If you aren't able to see all of the queries then ... it's likely due to the connection method rather than permissions. ... Select the Access database as the data source again and when ...
    (microsoft.public.office.misc)
  • Re: office 2003 Word mailmerge with Access
    ... Word 2003 uses a new default connection method, OLE DB, to connect to ... If you aren't able to see all of the queries then ... Select the Access database as the data source again and when ...
    (microsoft.public.office.misc)
  • Importing from Excel to Access
    ... a temporary table in the database, ... queries to populate the live tables. ... I need to import data from Excel into an Access ... >Do I need VBA to do this? ...
    (microsoft.public.access.externaldata)
  • RE: WORD XP mail-merge FAILS using ACCESS query
    ... why OLEDB does not show /all/ the queries. ... security - e.g. if you are using a workgroup database and have set up ... > round the problem by exporting from Access to Excel then merging into Word ... > certain Queries - so that I can print out labels and sometimes merge ...
    (microsoft.public.access.queries)