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 |
|
dirionis
Starting Member
3 Posts |
 Posted - 2005-07-20 : 05:40:14
|
is there any way to convert MS SQLServer database to Access format? -----------  |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-20 : 06:28:39
|
| I think what you need is to export data from SQL Server to Access. Isnt it?Use DTS or look for OpenRowset in Books On LineMadhivananFailing to plan is Planning to fail |
 |
|
|
dirionis
Starting Member
3 Posts |
Posted - 2005-07-20 : 06:54:20
|
| yeah :) .. u think that i'm fool .... i don't need to get data , i need to convert existing database with all relations and data:) ------------------------------------src : SQL Server database target: Access database with all structures from previous db and with data:0 |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-20 : 06:59:31
|
| You can use DTS/Import Wizard to replicate the table structures, but AFAIK it doesn't bring across the table relations. There may be a tool out there to do it; if not you can always write a bit of code to do it.HTH,Tim |
|
|
|
dirionis
Starting Member
3 Posts |
Posted - 2005-07-20 : 07:15:24
|
| can u say some detales :what is : 1. DTS/Import Wizar 2. AFAIK :) ------------------------ i'm not very familar with SQL Server (and no reason to change this situatin ... ) i need simple way to do this work :)------------------------ maybe there is several utils ? |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-20 : 08:09:26
|
| DTS = Data Transformation Services (the part of SQL Server that deals with imports/exports in a graphical manner)Import Wizard = A nice interface that builds DTS packages for youAFAIK = As Far As I knowJust thought of a way you can do it: Access Upsizing Wizard. You can find it in the Tools menu of Access. It should build the structure for you. Have a look in the Access help on how to go about it. |
|
|
|
|
|
|
Access and SQLServer