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 |
|
Mandrews
Starting Member
1 Post |
 Posted - 2003-02-26 : 11:12:41
|
| I am trying to import an Access 97 database into SQL server 6.5, and I have no idea how to do it. Im not all that familiar with SQl 6.5 but its what I have to use for the time being, can some one point me in the right direction? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-02-26 : 11:50:27
|
| If you have SQL 7.0 or higher on another server, you can set up DTS from Access to SQL 6.5. If not, probably the easiest way to do it is to use the Access Upsizing Wizard. There's a version for Access 97 on Microsoft's web site, search for "Access 97 Upsize" and you should find it.I use to have the link for it but MS keeps rearranging their web site and moving it. |
 |
|
|
|
|
|
Import in SQL 6.5