Exporting Text from PPT to Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ingle.kevin@gmail.com - 20 Feb 2007 22:20 GMT

I have created a VBA application in PowerPoint that concludes with a
comma-delimited text string as output. I would like to place an ADO
command after that point that appends the data into an Access table.
MSFT help files are helpless in this particular area!

Thanks in advance!

Reply to this Message

Paul Clement - 21 Feb 2007 14:38 GMT

¤ I have created a VBA application in PowerPoint that concludes with a
¤ comma-delimited text string as output. I would like to place an ADO
¤ command after that point that appends the data into an Access table.
¤ MSFT help files are helpless in this particular area!

Not sure if I have enough information here. How do you want the comma-delimited string written to
the Access table? Does the table already exist in Access? Is there just one column that you want to
write the data to?

Paul
~~~~
Microsoft MVP (Visual Basic)

Reply to this Message

ingle.kevin@gmail.com - 27 Feb 2007 19:45 GMT

On Feb 21, 8:38 am, Paul Clement
<UseAdddressAtEndofMess...@swspectrum.com> wrote:

> ¤ I have created a VBA application in PowerPoint that concludes with a
> ¤ comma-delimited text string as output. I would like to place an ADO
[quoted text clipped - 8 lines]
> ~~~~
> Microsoft MVP (Visual Basic)

I went about solving the problem a different way. I discovered the
needed ADO commands, then wrote what I needed to the MS Access table
-- the comma delimited string was nothing more than a compilation of
the variables that I was writing to the table anyway.

Thanks for asking!

Reply to this Message

VB Forum / Database Access / February 2007

Exporting Text from PPT to Access