On Jun 10, 5:19=A0am, BookerT <ch...@[EMAIL PROTECTED]
> wrote:
> 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. =A0The 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 =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
>
> > Are you really sure there is no way in access to "ex****t" the data
with
> > the column names included? =A0I 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. =A0In that tool it is easy to query the table,
> > select all the rows by clicking on the top-left cell, then right click
t=
o
> > get all sorts of copy/save/ex****t options. =A0The CSV option saves the
d=
ata
> > including the column names.
>
> > I assume that most such tools have that sort of option if you look in
th=
e
> > right place in the tool.
>
> > $0.10
>
> I am not SURE, which is why I am posting. =A0So I must be missing
> something, and I was hoping someone from this post would provide the
> missing link (Smile)- Hide quoted text -
>
> - Show quoted text -
We're talkin' MS-Access, right?
Right clicking on a table gives you the option to ex****t to Word Mail
Merge, which is CSV w/ field names.
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."
You can write some vba code to cycle through that list and automate
the ex****t w/ the transfertext method.
good luck
tim mills-groninger
|
