Results 1 to 2 of 2
  1. #1
    Derek is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Posts
    1

    Import to Excel from Access column of LOOKUP data type


    Hi Folks!

    I have a simple problem, and I'm hoping there is a simple solution. I'm importing into Excel a table from Access. One of the table columns is of the LOOKUP data type. The lookup includes an id# and a name. In Access, I've chosen to hide the id#. However, when I've imported the data to Excel, the Excel column does not display the name. It only displays the id#, which is not useful.

    How can I get the name itself to carry over to Excel?

    Thanks!

    D.

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    alter your query to include the table that has the english....and use that column instead.

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

Similar Threads

  1. Replies: 1
    Last Post: 10-29-2010, 02:53 PM
  2. Excel Import/Append Data (weekly)
    By MartinL in forum Import/Export Data
    Replies: 1
    Last Post: 08-12-2010, 06:14 PM
  3. Automate Import of Excel data
    By tpcervelo in forum Import/Export Data
    Replies: 2
    Last Post: 07-29-2010, 12:19 AM
  4. Using Import wizard to get Excel data
    By Jack Sheet in forum Import/Export Data
    Replies: 5
    Last Post: 07-16-2010, 09:44 AM
  5. Import excel sheets to access.
    By calexandru in forum Import/Export Data
    Replies: 0
    Last Post: 08-19-2009, 09:44 AM

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 - Senior Forums