Perl and Excel Graph Problem !

2002-10-18 Thread Mark Wildey
Hi There I have a script that takes a MS Access database and places a table into an Excel spreadsheet. Once the data is in Excel I want to generate a graph. All goes well in that the graph is generated, using the correct data and style, the graph title but the “PlotBy => xlColumns” is not honored

Can Someone Point Me in......

2002-09-10 Thread Mark Wildey
I’m very new to Perl and so far have built a script to read a large text file, create a MS Access db and subsequently run several SQL statements against my new db. I would like to present the information in html/web format and am struggling on the best way to build the html code and invoke the pa

Building SQL statement

2002-09-04 Thread Mark Wildey
True beginners question…. sorry I have a MS Access database that has lots of fields in it. When I build the SQL statement to insert data retrieved from a text file, rather than build a very long SQL statement I have used a “@column = $db->FieldNames()” subroutine to build a scalar variable ( cal