Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
brubaker
Starting Member
15 Posts |
 Posted - 2001-11-24 : 21:53:50
|
| I'm trying to move the table structure and data from an Access DB to a SSQ Server 2000 DB, but I'm having no luck.I used the import Wizard in DTS and created and executed the package, but when I look in the new database, none of the tables or data has been copied.I previewed the data in DTS and it looked like it had all of the correct data, but nothing happens when it is executed.Do I have to create the same table structure in the new database before it can import the data? I thought I could import the schema as well.Any thoughts? |
|
|
|
|
|
Access to SS2K using DTS