Re: I need to extract .pdf/.doc/.xls documents from an sql 2000 table.

Chris.lee.johnston@xxxxxxxxx (Chris.lee.johnston@xxxxxxxxx) writes:
I have a table in sql 2000 where I can see all the file names ex.
how-to-restore-cisci-3700.doc. The table is over 40mb in size. All
other tables less than 1mb. I am fairly sure that the files are stored
in the table and its just not a link to the file. I need to be able to
extract all .doc .xls .pdf files out of the table in their native
format so I dont have to retype all of my site documentation.

If you see a file name, that is a string. It's not even a link, it
is just a string. It is a piece of data, and it probably has a meaning,
but not having defined the table, nor having seen it, I can't tell you
what it means.

Are there any image or varbinary(MAX) columns in the table?


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Counting the occurence of a string ...
    ... table of string values that appear in all the urls viewed. ... INSERT statements with sample data. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: I want to parse @ArrayOfDays into @d1 through @d5
    ... @char - current char in string ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: OLEDB error with SQL 2005
    ... is to pass all string as empty string instead of setting status flag to ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.data.oledb)
  • Re: I need to extract .pdf/.doc/.xls documents from an sql 2000 table.
    ... I have stored an image, as an image datatype, in a SQL Server 2000 ... If you see a file name, that is a string. ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: Linking tables access - sql server 2005
    ... Another advantage of this method is that you don't need an ODBC setting on the local computer, ... Create a linked table to SQL Server without using a DSN ... Name of the table that you are linking to on the SQL Server database ... Function AttachDSNLessTable(stLocalTableName As String, stRemoteTableName As String, stServer As String, stDatabase As String, Optional stUsername As ...
    (microsoft.public.access.adp.sqlserver)
Loading