laziness, impatience, and hubris | |
PerlMonks |
Re: Flattening Access DB to XMLby Grygonos (Chaplain) |
on Jan 26, 2004 at 14:53 UTC ( [id://324153]=note: print w/replies, xml ) | Need Help?? |
This is a fairly easy task if you are on win32. Use Win32 OLE to access it like so
This is some code I wrote a while ago. It does work but it might not be exactly what you want. It only counts non system tables and non-linked tables. this was in a package.. I moved the constant object declaration into the sub for clarity when I pasted it here. Again.. this code has been tested and does work. I hope this can be of some use to you. P.S. If you open up the object browser in access, and you can check what the possible values of the attribute method are, so you can know which table you want to count. There is also a QueryDef collection if you are interested in counting those. Grygonos
In Section
Seekers of Perl Wisdom
|
|