Export data from SQL 2005 to Access

I am trying to export data from SQL 2005 to Access.
I have created all the tables in Access, all I want to do is export the data
from SQL to Access, I do not want the export process to create the table in
Access.
In SQL 2005 I right click on the database - Task - Export. I selected my SQL
Server database as the From Source and my Access database as the
Destination.
I selected "Copy data from one or more tables or views", then selected all
the tables that I want to export data from. Under "Mapping" button when I
click "Edit" the "Append rows to the destination table" is selected.
When I run the export I got the error "Error 0x002f210: Prepartion SQL Task:
Executing the query "CREATE TABLE 'mytable' (...) failed with the following
error: "Table 'mytable' already exists".
Why did it try to create the table ? Can I export only the data without
creating the table ?
Thank you very much.
You can export just the data. In the step where you are in
the Select Source Tables and Views, you need to select the
source tables/views on the left and on the right you select
the destination table in Access - specify the destination
table for each source table.
Verify the actions it's going to perform on the last page -
Complete the Wizard page. It should say "New rows will be
appended to the existing table" for each table.
-Sue
On Tue, 22 May 2007 12:04:31 -0500, "fniles"
<fniles@.pfmail.com> wrote:

>I am trying to export data from SQL 2005 to Access.
>I have created all the tables in Access, all I want to do is export the data
>from SQL to Access, I do not want the export process to create the table in
>Access.
>In SQL 2005 I right click on the database - Task - Export. I selected my SQL
>Server database as the From Source and my Access database as the
>Destination.
>I selected "Copy data from one or more tables or views", then selected all
>the tables that I want to export data from. Under "Mapping" button when I
>click "Edit" the "Append rows to the destination table" is selected.
>When I run the export I got the error "Error 0x002f210: Prepartion SQL Task:
>Executing the query "CREATE TABLE 'mytable' (...) failed with the following
>error: "Table 'mytable' already exists".
>Why did it try to create the table ? Can I export only the data without
>creating the table ?
>Thank you very much.
>