Re: How to Export Database into csv files

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.

Tim Mills-Groninger
...
> > 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!
>   Ed
Received on Thu Jun 12 2008 - 09:54:52 CDT