I have had to do this a few times... never did figure out the proper way to do it. It is usually a once-off, and by the time I figured it out, I could have done it manually.
I typically just create a Make Table query for each table: SELECT MyTableTable.* INTO MyNewTable FROM MyTable; and run the lot. Takes about 30 minutes for 100 tables start to finish, including creating the queries. Chad On 8/11/06, Joel Cass <[EMAIL PROTECTED]> wrote: > > The documentation in MS access seems quite vague about this area. I want to > get a list of tables from an access database to import into our own custom > data store. I have fiddled around and have come to the conclusion that this > is the query that must be run: > > SELECT MSysObjects.* > FROM MSysObjects > WHERE MSysObjects.Type =1 > AND MSysObjects.Flags=0 > IN '#accessFilePath#' > > Can anyone confirm if this is correct? I've tried this on a few various > files that I found lying around and have managed to get the same results > every time, but you just don't know what may change between versions when it > comes to MS products (just getting in on the whole debate here..). And it's > undocumented.. > > Any help is appreciated > Joel > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---
