Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2006
    Posts
    47

    Unanswered: Displaying Data From Access in Formatted Excel (or maybee Word)

    I need to create a printable confirmation call list with some basic formatting preferably in Excel (or maybee Word) based on a few selections and hitting a button.

    How do people usually do this?

    I can think of some complicated ways with Recordsets and formatting via code but I just wanted to check that there isn't some simple way I am overlooking.

    I learn everything via Books and this forum so I often miss some simple ways of doing things.

    Any help or guidance would be greatly appreciated.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Well, instead of using word, why don't you use the Access Report Writer?

    As for Excel formatting; there's an excellent sample from Pootle Flump somewhere in the Code Bank.
    George
    Home | Blog

  3. #3
    Join Date
    Oct 2003
    Location
    Chicago, IL
    Posts
    34
    The way I would do it is exactly what you said, which is I would create a Macro in MS Word or Excel (depending on what your choice is), to read the data from the MS Access Dataset into a recordset, and populate a table in the document through looping.
    DigiOz Multimedia
    http://www.digioz.com

  4. #4
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I'm a fan of using Access reports as there is so much power on different ways to format data in an Access report.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I'd use a report too.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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