On Jun 9, 7:08 pm, yf...@[EMAIL PROTECTED]
(Malcolm Dew-Jones)
wrote:
> BookerT (ch...@[EMAIL PROTECTED]
) wrote:
>
> : I am just changing from one database to another (A CRM solution)
>
> : And in our fact finding, we wanted to test the im****t function into
> : the new CRM. The im****t tool can take as input files, sv files, and
> : it will use the first row as the header information to create the
> : equivalent columns in the destination table.
>
> : So instead of copying and pasting by hand, I figured there was a way t
> : oex****t table information to include the column names.
>
> : On Jun 9, 2:34 pm, 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 Individual 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
>
> Are you really sure there is no way in access to "ex****t" the data with
> the column names included? I haven't used access for quite some time,
but
> I thought it had that sort of capability if you choose the right
options.
>
> I often plsqldeveloper. In that tool it is easy to query the table,
> select all the rows by clicking on the top-left cell, then right click
to
> get all sorts of copy/save/ex****t options. The CSV option saves the
data
> including the column names.
>
> I assume that most such tools have that sort of option if you look in
the
> right place in the tool.
>
> $0.10
I am not SURE, which is why I am posting. So I must be missing
something, and I was hoping someone from this post would provide the
missing link (Smile)
|
