AIIIIEEEE! Guys, can someone help me convert a .BAK file to a .CSV spreadsheet?Basically I've got this database backup file but need it in CSV to import it into a new database I'm using. Now I'm not too sure how to do this or convert this. I need it to be a free tool, or perhaps one of you have SQL server or something else that can make this conversion?
11/4/2008 2:09:40 PM
50 dollars[Edited on November 4, 2008 at 2:11 PM. Reason : dead serious, I don't do people's jobs for free]
11/4/2008 2:11:08 PM
Well jeez even some free guidance for a fellow alum then? I don't have any money to spend and I just need help with a conversion. i have the .BAK file in a 29 meg zip. I used a freeware excel converter that did this but the output was garbage
11/4/2008 2:15:37 PM
i'll do it for $85]
11/4/2008 2:15:47 PM
if it isn't that big of a database (could get tedious if you have a lot of tables) maybe you could try...1) download microsoft sql server express2) restore database from .BAK file3) open the table4) copy/paste into excel5) save as .csvnot sure that works, but maybe give it a try.
11/4/2008 2:19:25 PM
if you right click on the db in sql express, there's a data export under tasks where you can do multiple tables[Edited on November 4, 2008 at 2:22 PM. Reason : rather than open table copy/paste]
11/4/2008 2:21:41 PM
^ yes I suppose that would be easier
11/4/2008 2:23:36 PM
i'll send my bill in the mail
11/4/2008 2:28:51 PM
11/4/2008 3:47:34 PM
yeah, you can't go straight from a bak to plaintext.restore it into sql server express and then use something like DTS
11/4/2008 4:53:57 PM