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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-12-17 : 08:33:22
|
| Rick writes "do you know how I can convert .sql to mdb files?is there any such software that do this job?" |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-12-17 : 17:37:39
|
| A .sql file could include statements to create/delete databases, create/delete tables, select,insert,update,delete data.An mdb file is an access database.So I'm assumming what you want is take .sql files which were meant to be executed on a sql server and convert that to access.You could run the .sql files in Query Analyzer for SQL Server if they create a database for you and add data then you can use DTS to export the data to an access mdb database. Alternatively you could also create an access data project and connect it to the sql server.If you don't have SQL Server you can download a 120 day evaluation copy from microsoft. |
 |
|
|
SMerrill
Posting Yak Master
206 Posts |
Posted - 2002-12-23 : 13:20:02
|
| If you have a SQL Server database that you wish to convert to MS Access, be advised that Access XP has a way to open SQL Server directly. This does not actually need to convert the database to an MDB, but instead connects to it as is.When you open up Access XP, click the New File tool to bring up a side window. Under the NEW heading, please click "Project (Existing Data)" and you will see a connection box. Tell Access how to log into your SQL server database with an administrator password, and you will be astonished to find all of the tables, relationships, views and stored procedures have become available directly within Access.--SMerrillSeattle, WA |
|
|
|
|
|
|
|
|
inquiry