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 |
|
mbevon
Starting Member
41 Posts |
 Posted - 2002-05-17 : 10:20:45
|
| I've a access table how do i import it into SQL2000?thanks |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-05-17 : 10:28:53
|
| Look up DTS (Data Transformation Services) in Books online... It will have the information you need |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-17 : 10:29:56
|
You can use Data Transformation Services (DTS), there's an Import/Export wizard that is actually pretty good, it can certainly do the job. You can run it from Enterprise Manager (right-click on the database and choose Import data, might have to look under All Tasks), or look under Start:Programs:Microsoft SQL Server.Another method is to use the Upsize to SQL Server wizard, it's built into Access 2000 and higher, or you can download and install it for Access 97 from http://www.microsoft.com Edited by - robvolk on 05/17/2002 10:30:22 |
|
|
|
mbevon
Starting Member
41 Posts |
Posted - 2002-05-17 : 14:41:51
|
| THanks Guys |
|
|
|
|
|
|
Importing Access Table