Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
IRBradles
Starting Member
5 Posts |
 Posted - 2007-12-04 : 23:46:37
|
| Hi SQL Team,Thaks for your assistance for my last date-time issue.Have a small project where management, using third party software storing the data on SQLServ 2005, were storing files on a shared drive and recording path/filename in the database. I have an Excel VBA workbook that queries the Server for a list of filenames (at present 55+, soon to grow over 300), opens them all in turn, parses, and copies the data into one sheet for presentation to management. This is all working quite nicely.Now management are (for security reasons) forcing the software to store the files internally for version control, and thus I can't read from the source documents anymore. The files are now stored in a Table "MDocument" as binary data "Doc". I can guarantee that all files stored are .xls, but does anyone know a way in either T-SQL or Excel VBA that I can extract these and either open, them or at worst save temporary copies? (Will Result in ~120MB of Temp xls files but that is acceptable.)Brad |
|
|
|
|
|
xls Files Stored as Binary