VBA Microsoft Access and SQL Server

Subject: Power Point Slide presentation retrieving and updating information
into a SQL Server database.

I am currently working on a project with Power Point. The requirements for
the project is that I must 1) take input(s) in the Power Point and insert it
into a Microsoft SQL Server database. Then 2) I must be able to extract the
information from the Microsoft SQL Server database and re-populate a Power
Point template with the information retrieved from the Microsoft SQL Server
database.

The issue is this 1) Power Point is a flat file which means that it has no
intelligence. However, we can add intelligence to the flat file by means of a
desk top programming language Visual Basic for Application (VBA). 2) Visual
Basic for Application (VBA) is the industry standard for embedding
intelligence into a flat file. VBA is used by industry to place embedded
objects into Excel, PowerPoint, Microsoft Wrod and Microsoft Access. 3) The
problem is that VBA was NOT originally designed to connect to a Microsoft SQL
Server database. Originally it was designed to connect to Excel and Microsoft
Access. Also, after much Googling , I get the impression that VBA does not
supports ADO.NET access to Microsoft SQL Server.

My thoughts are this, if VBA connect access Microsoft SQL server directly
then maybe we can use it to connect to Microsoft Access and then have
Microsoft Access feed into a Microsoft SQL Server database.

(I.E. shown below...)

Solution # 1)

My own personal recommendation for inserting data from Power Point to
Microsoft SQL Server database: “Embed VBA objects into Power Point 2) then
have the embedded VBA objects in the Power Point slides feed into a Microsoft
Access database. 3) Have the Microsoft Access database feed into a Micrsosoft
SQL Server Database.” – this will ensure that our data is stored in a SQL
Server database.

My recommendation for outputting data from Power Point to Microsoft SQL
Server database:

“Have the Microsoft SQL Server database feed into a Microsoft Access
database. Then have the Power Point Slides retrieve the data from the
Microsoft Access database.


Solutions #2)

My own personal recommendation for outputting data from Power Point to
Microsoft SQL Server database:

“Have the Microsoft SQL Server database feed into a Microsoft Access
database. Then have the Power Point Slides retrieve the data from the
Microsoft Access database.

Request for comment/recommendations . . . also, if somebody worked on a
similiar project, know how to connect directly to SQL Server from VBA, or
know of an application that can perform the functionality stated please reply
back to this posting or my e-mail jpdrake@xxxxxxxxxxxx
.

Relevant Pages

  • Re: Changing linked SQL Server tables in code
    ... using the Microsoft SQL Server ODBC driver. ... We've set up a test SQL Server database. ... I've found some code examples here of relinking ODBC back ends to ...
    (comp.databases.ms-access)
  • ANN: MSSQL LogManager v1.1.0.5 has been released!
    ... The MSSQL LogManager product family is a set of tools which helps you to keep track of data changes in your Microsoft SQL Server database. ... Server-side logging mechanism ...
    (microsoft.public.sqlserver.tools)
  • ANN: MSSQL LogManager v1.1.0.6 has been released!
    ... The MSSQL LogManager product family is a set of tools which helps you to keep track of data changes in your Microsoft SQL Server database. ... Server-side logging mechanism ...
    (microsoft.public.sqlserver.tools)
  • Re: access-SQL Server 2000
    ... Can I make replication work from Microsoft SQL Server and Microsoft ... database to the SQL Server database? ...
    (microsoft.public.access.replication)
  • Re: DataSet.GetChanges() in RowChanged(DataRowAction.Add)
    ... if the way synchronization needs to be handled changes in the ... > data stored in an SQL Server database. ... > GetChanges() call, but I feel that this workaround is not my best choice. ...
    (microsoft.public.dotnet.framework.adonet)