Re: How to Export Database into csv files

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
Received on Mon Jun 09 2008 - 16:43:56 CDT