--- In [email protected], "brother.gabriel" <brgabr...@...> wrote: > > I was actually looking at those. I am trying to get information > out of a M$ Access database so I can use it. So far I have been > exporting one of the forms which I created in the database and > then regexing it with NoteTab to create an initial ini file that > I could work with using PP. Then I ran into the problem where I > need to access the data from two years at once, so it messed up > my ini scheme. I don't know anything about xml, really, except > that one can use "categories" and "subcategories". I have thought > about using an ini file for each year, which is nice, but I don't > have any way to specify the year automatically when I export it > from Acess. The most efficient thing to do would be to simply > access the database itself using PP, but I don't think PP's > database plugins will do that - don't they only use OBDC? Is this > something I could do with the COM plugin?
If the data is in Access, might be best to read it from Access. Do you have the VBA reference (chm help file) for your version of MS Access? For example the one for Access 2003 is here: <http://www.microsoft.com/downloads/details.aspx?familyid=0447c5a0-5e58-4e69-b90e-c42ec7dbf887&displaylang=en> There are similar downloads for Word and Excel. I've been able to extrapolate info from those help files to access Word and Excel data in Powerpro scripts. I have been using the soon-to-be-released version .72 of the com plugin. Regards, Sheri
