[thelist] MSSQL 2005 .bak file - extract data?

Ken Schaefer Ken at adOpenStatic.com
Mon Jun 1 20:18:46 CDT 2009


.bak files are usually backup files.

Restore the database to the DBMS, then you can export the data easily (via SISS etc) or even cut-n-paste

Cheers
Ken

________________________________________
From: thelist-bounces at lists.evolt.org [thelist-bounces at lists.evolt.org] On Behalf Of rogerharness at comcast.net [rogerharness at comcast.net]
Sent: Monday, 1 June 2009 3:00 PM
To: thelist at lists.evolt.org
Subject: [thelist] MSSQL 2005 .bak file - extract data?

'Volters,

I realize I'm a little over my head with this, but does anyone have any suggestions on how I can extract data from an SQL 2005 .BAK file, for export into Excel/Access, in a relatively simple manner?

I'm trying to install MIcrosoft SQL Server 2005 on my system so I can open this file up, but I'm struggling a bit to figure out how to view the data, even after installing this software.

Are there any simple solutions to get to that data, other than relying on a vendor to get the data to me in another format?

Thanks as always!
-Roger Harness


More information about the thelist mailing list