I already have tables in my SQL Server 2000 database. I have several things
that I need to do -
(import sql server 2000 tables into MS Access database for conversion)

1). cleanup the data from MS Access

2). break out the data from some of the MS Access tables into sql server
tables

3). only need to migrate the data

what is the best way to do this?

Why load the data into Access, clean up the data and then load it back to
SQL Server? Assuming there is some logical reason have you tried using the
Import/Export Wizard? That's perhaps the easiest way to get started with
DTS.

--
David Portas
SQL Server MVP
--

The data is currently in a MS Access database. The new table structure is in
our SQL Server database. We imported our SQL Server tables into the MS
Access database. Is it better to clean the data in MS Access? What is the
best way to transfer the data to our SQL Server tables? We don't want the
data types on the columns changed in our SQL Server tables which happens when
we use the import/export wizard.

"David Portas" wrote: