+ Reply to Thread
Results 1 to 3 of 3

Import external data

  1. #1
    Registered User
    Join Date
    10-10-2006
    Posts
    22

    Import external data

    I am trying to import information from an access file. I take the following steps Data on the menu bar Import External Data and then New Database Query. The dialog box lists only <New Data Source>.
    Nothing else on the list... not access... not even excel. Where did my data sources go?

  2. #2
    Forum Contributor
    Join Date
    02-28-2006
    Posts
    690
    You can write a query in access to get the data you want, and then use a macro to send it to a specific sheet in an excel spreadsheet, other sheets can then process the data. Would this be a possibility?

  3. #3
    Registered User
    Join Date
    10-10-2006
    Posts
    22
    The problem is not what I am trying to do, but the fact that the "Choose Data Source" dialog box lists no database sources ecept <New Data Source>.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1