Results 1 to 3 of 3
  1. #1
    T1969 is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Feb 2017
    Posts
    25

    Query missing from list - Import to Excel

    I have a problem where I cannot export to Excel as 2010 max 65k rows on clipboard.



    My alternative method of importing to Excel will not work on some Queries as they cannot be seen.

    I have been importing the queries to Ecxel
    My problem now comes that I have created a new query looking at two tables with some calculations in (NZ) call it QueryZ. I cannot see the queries in the list from the Excel Data transfer option.

    The other Queries in the database can be seen OK.

    If I create another Query off QueryZ this will not show either.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Do it the other way.
    export the query from access to excl. this always works.

  3. #3
    T1969 is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Feb 2017
    Posts
    25
    I have been looking it up today so will give it a go at work tomorrow, export without formatting seems to be the answer ?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Import excel data to query
    By maxiz1 in forum Import/Export Data
    Replies: 4
    Last Post: 06-08-2016, 11:06 PM
  2. Import query having parameters from excel
    By scorpion99 in forum Queries
    Replies: 1
    Last Post: 01-02-2014, 02:11 PM
  3. Import access query data into excel file, using excel vba
    By exceljockey in forum Import/Export Data
    Replies: 3
    Last Post: 11-15-2013, 02:36 PM
  4. Replies: 2
    Last Post: 08-14-2012, 04:24 AM
  5. Import Excel sheet with query
    By tpcervelo in forum Queries
    Replies: 1
    Last Post: 08-03-2010, 07:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums