Graph from Access

[jacco van der Ven]

I have an Access database with some temperature's, I want to create an graph from this database.
Is it possible to do this automatic?

Maybe someone can help me with this?

Jacco

[Steve Horn]

You mean outside of HB? Haven't tried it, but you should be able to export the raw data to Excel, then graph it there. Inside HB?? I have no clue.

[jacco van der Ven]

Yes, I mean outside HB, and automatic with vbscript or something?

[Richard Naninck]

You probably found this thread as well, but if you didn't you might find some info here..

http://cebotics.com/forums/viewtopic.ph ... ph#p449789

[jacco van der Ven]

Yes, I use this already but that will not work with access I think.

Jacco

[Timoh]

I suspect you could get GNUplot to work with Access. Just create a vbscript that connects to Access db you want, suck out the data and write to a file in the format that GNUplot wants.

And you might be able to get the grapher for sql setup as well. I didn't take a look, but if it uses some form of connector such as ODBC, you can point that to your access db instead of an SQL db.

Tim

[jacco van der Ven]

Ok, I will try that, thanks for your advice!

[Steve Horn]

This may be oversimplifying and not what you had in mind, but have you tried to graph the data from within Access? I did a quick Google search on "Graphing MSAccess Data" and got several hits returned that, quickly looking at it and not trying it, seemed to indicate that it's possible.

[edgar]

Hello,

I use GNUPLOT for graphing. I use Autohotkey scripts that I convert to Executable files to parse HB logs and format them for GNUPLOT. As long as you can get your Access data into a data format GNUPLOT can accept you are good to go. GNUPLOT uses instruction/plotting files (plt) to load, plot, and output graphs and can be executed from a command line. I have HB doing this. It sounds a little clunky but works very well for me, especially since I am not very good at writing java/vb scripts.

v/r

Kevin