Re: How to Export Database into csv files
Date: Thu, 12 Jun 2008 07:54:52 -0700 (PDT)
What's the problem, Ed? The table prefix? Querying the MSysObject table?
As long as the poster is using a reasonable naming convention he can move data from Access (which has it's place in the deity's grand plan) to Oracle (which has a different, but equally valid place). I gotta move stuff between the two on occassion, but mostly one-off tables to complete a particular analysis.
> > you can list all of the tables with the sql statement
> > SELECT MSysObjects.Name
> > FROM MSysObjects
> > WHERE (((MSysObjects.Name) Like "tbl*"));
> > Assuming that your table names start with the prefix "tbl."
> yuck, poohey!
Received on Thu Jun 12 2008 - 09:54:52 CDT