Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004

    Unanswered: Cannot Import External Data


    I was hoping someone could help me with this issue. I am trying to import external data from an access database. The data that i am trying to import is from a query. Now the issue here is that when i connect to the database that i need to export the data from, i can only see the tables. I am not able to see the queries.

    Now, one thing that i noticed was that i was able to import data from a query from another database, but not this one. This leads me to beleive that there is something going on with this database.

    Thanks for any help,

    Steve G

  2. #2
    Join Date
    May 2005
    Are you importing the data into excel from access using data--> Import external data ? If yes, then you are in the same boat as mine, because i had faced a similar issue last year. After much investigation, I realised that if the query contains an expression such as (UDF or access functions having no similar equivalence in excel), then that query is not visible while trying to import the data into excel.
    A workaround could be that you export the data from the query into another table and then import that data into excel.

  3. #3
    Join Date
    Feb 2004
    And another way would be to create the query in MSQuery referring to the data tables verses the query in MS Access.


  4. #4
    Join Date
    Apr 2004
    Derbyshire, UK
    Provided Answers: 2
    Hi Steve

    Just one thought I had.

    Are you connecting to the backend of a split DB?

    If so, then the chances are all the queries are in the frontend, with table only in the backend !!?

    As I said, just a thought.


  5. #5
    Join Date
    Sep 2013
    What kind of things are UDF's in this instance? I have a similar issue (although I can see the table, when I import it I just get headers and blank rows) but the only criteria on my query is "*" to ensure one of the fields is populated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts