How to read object attached to Excel file into Access Database?

[kak.mca]

Hi,
I have written VBA code to read Excel data in cells into MS Access.
I have to read Objects also attached to Excel file (like MS Word, Text File, PDF files). I am not understanding how to do this.

Can anybody please help me!

Thanks.

[June7]

You mean you have cells in Excel set as hyperlink to documents? You want to save those documents in an Attachment field in Access table? Or you just want a hyperlink in Access?

Review:
http://office.microsoft.com/en-us/ac...001213852.aspx
http://blogs.office.com/b/microsoft-...cess-2007.aspx
http://www.allenbrowne.com/casu-09.html
http://allenbrowne.com/func-GoHyperlink.html
http://www.brighthub.com/computing/w...les/59992.aspx

[kak.mca]

Hi June7,
Thanks for your reply.

I am NOT talking about hyperlink inside cell.

In the Excel Application:
Insert Tab | Text Group | Click on Object | Select Create From File tab => We can Insert external object, right!
I have to read Objects also attached to Excel file (like MS Word, Text File, PDF files). I am not understanding how to do this.

Could you please help me on this!

[June7]

Oh, never done that with Excel.

I googled: extract embedded objects from excel

Maybe this one will get you started http://www.syntax-example.com/Forum/...-hd-25853.aspx