Link charts to Access, SQLServer, or Text Files

[Alan Z. Scharf]

Hi,

Is there a way to link charts to Access or SQLServer tables, or
comma-separated text files?

Ideally, also link text fields also?

Thanks.

Alan

 

[Alan Z. Scharf]

Studdy,

I know this can be doen, but it is very awkward to do.

2. I'm look at least for a way to connect PowerPoint charts to a .TXT or
CSV file, which I could easily export from SQLServer.

Freelance, 15 years ago, could link individual charts to individual CSV
files, thus allowing dynamic updates of charts simply be re-exporting
SQLServer data to .TXT files of the same name..

It's hard to believe there's no way to do at least this in PowerPoint in
2007.

Regards,

Alan

 

[Ute Simon]

Is there a way to link charts to Access or SQLServer tables, or

Alan, have a look at the add-in Datapoint:
http://www.presentationpoint.co.uk/software/datapoint/index.htm

Best regards,
Ute

 

[Alan Z. Scharf]

Studdy,

Thanks again for your reply.

I had missed the Import Fie on the Edit menu.

However, that still doesn't do the trick since the data is apparently not
updated from the file.

The edit paste-link seems to do the trick.

SPlease also see my other post.

Thanks again.

Alan

 

[Alan Z. Scharf]

Steve,

Thanks for your reply.

Apparently the Edit Paste Link does work, including automatic update of
chart once I save a change in CSV file or overwrite it with new file and
then open the Ppt file.

That's what I needed, to be able to print an updated version of the
presentation.

Thanks again for your detailed reply, which made me re-think the Edit
Paste approach.

Alan

 

[Alan Z. Scharf]

Ute,

Thanks.

That looks like it will do the trick also. It looks like it involves
constructing a SQL statement for each chart, in lieu of linking each chart
to a CSV file.

Alan