[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