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 |
|
writer
Starting Member
2 Posts |
 Posted - 2009-03-31 : 09:15:20
|
Hi,I am a new user of a hosted web site SQL Server 2005. I have 2 Access mdb files that I need to export into 2 new SQL Server databases on the site. If I use the Import/Export data wizard accompanying the express MS SQL Server software, there is a problem with external connections.The other option is not to use the wizard to connect, but instead to use the SQL Server's management panel inside the hosting site. This has a query tool that permits running SQL Server scripts: you can either run the script or cut and paste the script itself into the management panel query window. I've successfully used this and it has correctly built the database's tables, etc.Probel is that I don't have these 2 mdb files converted into a SQL Server scripts. Is there a way to do this? As a newbie with limited skills, it would need to be a fairly basic solution. Or, is there a conversion wizard or tool that can export mdb files as SQL server script files?Any help or suggestions would be greatly appreciated.  Kind Regards,writer |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2009-03-31 : 15:04:31
|
| What do you mean - by connverting the mdb files? are you asking , if programming logic can be converted to sql? or do you mean transfering the objects , ?Jack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
|
|
|
Converting 2 mdb files to SQL server scripts