On Jun 9, 11:34=A0am, BookerT <ch...@[EMAIL PROTECTED]
> wrote:
> What is the best way to ex****t any of the following:
>
> 1. Whole Schema, or
> 2. All Tables with Row Header information, or
> 3 =A0Individual tables with Header row information
>
> I opened up access and ex****ted all of my tables into csv files, but
> it did not include the column name information.
> I am trying to ex****t the 1st row, so that I can im****t into another
> type of database that would recognize the 1st row as the field name
> row.
>
> Thanks
It depends.
What do you really need to accomplish?
One solution might be to look at the all_tab_columns view. Another
way might be to hard code the column names into another csv file and
concatenate them. You don't do the access equivalent of "select *
from table" do you?
The best way for you might not be the best way for anyone else. Also,
"ex****t" in the Oracle world generally refers to specific tools that
don't do what you want.
There are tools for making csv files, as well as techniques that avoid
using access. There is probably some way to do what you want with VB
or some other MS-thingie, so you can do it directly with access, but I
wouldn't know about that. You might google for it, though. I wrote
some program in an obscure tool that used COM to do magic nice things
directly into ridiculously complicated spreadsheets, then the tool
stopped officially sup****ting it. It was a real PITA, anyways, and
I'm not looking forward to rewriting all that stuff when the tool
actually stops sup****ting it.
Maybe cdo.tools or an access group might answer better.
jg
--
@[EMAIL PROTECTED]
is bogus.
Duuuuuhhhhhh... http://news.cnet.com/8301-13505_3-9962935-16.html
|
