Extracting documents from OLE field

  • Thread starter Danny J. Lesandrini
  • Start date
D

Danny J. Lesandrini

I have a client who uses Access 2003 to work with data in a SQL Server. One
field is the SQL Server equivilent of the Access OLE field, where they store
documents. Mostly PDFs but probably some DOCs and XLSs.

Now they want to abandon this practice, extract these files to folders and store
only the path to the newly extracted files. They used to have some code around
to do this, so they say, but can't find it anymore.

Can this be done in VBA code? Does the fact that it's Access to SQL Server
make a difference?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting audio from an Access Database 1
Access 2007 Database - OLE / ACE 2
OLE Objects 2
OLE Object Links 0
Extracting OLE data in "Picture" or "Microsoft Word Picture" format 0
Use path as string from OLE Object field 0
Save OLE Object via VBA to linked SQL Server 2005 table 0
format problem when extracting ole object field to a file 0

Top