Anyone know how to convert SQL files to MDB?

[Barry Scott]

I have a sql back up which i would like to open and use locally or restore to a server.

I've only had a quick browse, but have a feeling someone on here may have an answer. Does anyone know of any programs that can do this please?

Thanks

[land_of_bo]

Is the DB less than 4GB?

If so, you should be able to download the free MSDE

http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en
 
and restore your database into that

[Barry Scott]

Is the DB less than 4GB?

If so, you should be able to download the free MSDE

http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en
 
and restore your database into that

Yeah, it's only 360mb. I'll give that a whirl, thanks Mr Bo.  

[STFC_Manc]

Have you got a mysql server on your PC? I use Xammp http://www.apachefriends.org/en/xampp.html I installed this and then i could set a sql server on the pc.  If you need a hand, give me a pm.  It took me a while, but its really east to set up.

[Barry Scott]

Thanks. I'll have a butcher's at that. I can't seem to get MSDE working how i thought it would.

I'll download Xammp and have a go later tonight or tomorrow and then drop you a pm should i get stuck.

Have you used it? Can i, for want of a better word, simply 'unpack' the database?

[Lash_sumthin]

yeah we used xammp at uni to get an sql server on the go, nice little app

[STFC_Manc]

Thanks. I'll have a butcher's at that. I can't seem to get MSDE working how i thought it would.

I'll download Xammp and have a go later tonight or tomorrow and then drop you a pm should i get stuck.

Have you used it? Can i, for want of a better word, simply 'unpack' the database?

well you need to set it up first, then export your database from where it is now, in mysql form then import it, quite easy.