Hello all!

I would like to create a database DTS package to import a data from MS
Access table into the SQL Server 2000 database.
I use a import wizard to select data source (MS Access) and destination
database (MS SQL Server 2000) and to import a table. At the end I name a
table as: [NMR].[dbo].[output_name_table].
After that I select Schedule DTS package for later execution. I select
every Thursday on 14:56. Then I click NEXT and I got the error:

Microsoft ODBC Access Driver - Syntax error in CREATE TABLE statement

Microsoft ODBC Access Driver - Syntax error in FORM clause

When I import data manually without creating DTS Package everything is
working correctly. I can create a table etc. When I try to do it using a
DTS import fails. Could you help me fix this problem?

Kindest regards
Marcin from Poland

*** Sent via Developersdex http://www.developersdex.com ***

Include the column ABC in to the DTS and once it's done use Alter table and
drop Column ABC.

This is not a solution but work around.

-MB


"SamK" <SamK (AT) discussions (DOT) microsoft.com> wrote