Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Producing macro to retrieve data from Access (2000)

    Is is possible to produce a macro in Excel to transfer data from Access into Excel?

    In access these fields are:

    CDRL Ref Title MaxOfRev MaxOfIssue Date


    They need to be transferred to the fields in Excel:

    Ref No Title Version Issue Date

    Any help would be appreciated.

    Justin

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Producing macro to retrieve data from Access (2000)

    Excel has built-in features for retrieving data from an Access database:
    - Data | Import External Data | New Database Query
    - The VBA method CopyFromRecordset

    Type CopyFromRecordset somewhere in the Visual Basic Editor and press F1 to get online help.

Posting Permissions

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