Import data from Access Database?

MikeSr · Post by **MikeSr** » Wed Oct 13, 2010 5:14 am

I am evaluating Dplot. Our data is stored in an access database. How do I import my data ?
I have exported the data into excel and then used the Dplot inteface within excel, but I would like to avoid that step if possible.
Also, will the Excel inteface become available for Excel 2007 ?

Post by **DPlotAdmin** » Wed Oct 13, 2010 7:53 am

The DPlot Add-In currently works with Excel 2007 and both 32- and 64-bit versions of Excel 2010.

Sorry, but I know next to nothing about Access. I keep hoping somebody like you will write the VBA for me

MikeSr · Post by **MikeSr** » Wed Oct 13, 2010 8:05 am

Thanks for the reply. I didnot look close enought at Excel 2007 as it shows up differantly in 2003.
My concern using excel for my data conversion is the 65K limit within excel.
How would I use Dplot to handle the 65K limit in generating the graph?

Do you have examples for writing the plug in in VBA?
I could then take a look at the code and determine the level of difficulty in writing the plugin.

As soon as I hear back, I will purchase your software. It truly is very nice.

Post by **DPlotAdmin** » Wed Oct 13, 2010 8:27 am

If you're using Excel 2007, you're no longer limited to 65536 rows. The limit for newer versions is > 1 million rows. (If you want to save a spreadsheet, you'll need to use the newer .xlsx format and, of course, Excel 2003 users won't be able to open the file.)

To take a look at the Add-In code see DPlot's Help topic "Using the DPlot Interface Add-In for Microsoft Excel", scroll to the bottom and see "Editing the Add-In". That page is also available online at http://www.dplot.com/help/index.htm?helpid_addin.htm