Re: How to Export Database into csv files

On Jun 10, 5:19 am, BookerT <ch..._at_mierbo.com> wrote:
> On Jun 9, 7:08 pm, yf..._at_vtn1.victoria.tc.ca (Malcolm Dew-Jones)
> wrote:
>
>
>
>
>
> > BookerT (ch..._at_mierbo.com) wrote:
>
> > : I am just changing from one database to another (A CRM solution)
>
> > : And in our fact finding, we wanted to test the import function into
> > : the new CRM.  The import 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
> > : oexport table information to include the column names.
>
> > : On Jun 9, 2:34 pm, BookerT <ch..._at_mierbo.com> wrote:
> > : > What is the best way to export 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 exported all of my tables into csv files, but
> > : > it did not include the column name information.
> > : > I am trying to export the 1st row, so that I can import 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 "export" 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/export 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)- Hide quoted text -
>
> - Show quoted text -

We're talkin' MS-Access, right?

Right clicking on a table gives you the option to export 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 export w/ the transfertext method.

good luck

tim mills-groninger Received on Tue Jun 10 2008 - 14:13:24 CDT