Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Good morning.

    We are in the process of having point of sale display screens in our offices.

    We want to create presentations based upon fields for each record (which would represent one slide per record), but the data is stored within a SQL database. We do not really want to have to manually re-produce this information and would rather be able to be imported at the minimum from the sql database on a regular basis.

    Any pointers...
    Best Regards,

    Luke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    There are several ways to approach this:

    You could write a script on the server that loops through the records of the relevant table and uses Automation to create a PowerPoint presentation on the server. This presentation can then be downloaded to a local machine.

    Or you could write PowerPoint VBA code that connects to SQL Server, opens a recordset, loops through the records and populates a presentation.

    Both require a mixture of programming skills.

  3. #3
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='784187' date='12-Jul-2009 11:54']There are several ways to approach this:

    You could write a script on the server that loops through the records of the relevant table and uses Automation to create a PowerPoint presentation on the server. This presentation can then be downloaded to a local machine.

    Or you could write PowerPoint VBA code that connects to SQL Server, opens a recordset, loops through the records and populates a presentation.

    Both require a mixture of programming skills.[/quote]

    I think the latter would be better for us as a company. Any pointers ?
    Best Regards,

    Luke

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

Posting Permissions

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