any SQL 2000 experts on here.. got a question

[jfish]

I have a table within a database on SQL 2000 SP4 and one of the columns holds the binary format of Word/PDF documents

I need to extract these files, how can it be done ?

 

[Him Her]

For a small number of documents use ODBC, set up a DSN and insert the database field in Word then copy and paste the result before saving. For a larger number of documents, script it in VBA.

I'm sure there are other ways just this one sprung to mind first

 

[oneman]

I was also going to suggest ODBC and pull the records into access should be easy enough else a simple VBS using ADODB would allow you dump the files to a folder on your PC. Here is some sample code for importing and export binary data to SQL.

Read and write SQL image data, store binary file to sql table.

 

[jfish]

thanks .. will look at the vbscript

 

[jfish]

right managed to get further, got a vbscript to pull in the data and write the file to the local disk, however when opening up the file be it pdf or word - it is corrupted so think the write process isnt doing it correctly so need to read more into this.