Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Thanked 0 Times in 0 Posts

    External Data (XP)

    Im using an Access database voor CRM data. When I open a new template in Word (fromout Access) I can use the the option Insert Field to automatically fill in the customers name etc in my Word document. At FieldNames I select DocProperty to insert the Fields in my Word document.

    Now I want to use the same option in Excel, but here i can't find that option. Does anyone have a solution for me?


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: External Data (XP)

    Hello Gerben,

    Excel workbooks are very different from Word documents, and Excel doesn't have the concept of fields. On the other hand, it is easy to get data from Access into an Excel worksheet (Data | Get External Data | New Database Query...); you can then use formulas to refer to these data in other cells.

    Perhaps somebody will be able to give more specific help if you tell us what you want to accomplish in Excel.

Posting Permissions

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