Tuesday, February 14, 2012

data from mdf to excel

Hello guys,
I have an mdf file and I need to get the data
from there to excel (not vice versa). Can I do that
without installing ms sql server. I have heard that
odbc sql drivers help but I don't know how.
I'm a beginner in this area. Please help me.

Best regards,
JessicaI don't believe you can do this. If you attach the mdf file to a SQL Server you can easily do this with DTS.|||If the MDF file is readable in another database tool you can export it to CSV then import it into excel... just one option|||U must install SQL Server,and attach the database.Then using sql server's data import & export tools to do it.|||Thank you guys, it seems that I still have
to install ms sql to do this.

Jessica

No comments:

Post a Comment