Help Plz

[cmatni]

Hi guys,
I have a file excel with around 1500 record one column (one field), but each record is linked into a pdf file, i want to import these records into MS access to do search queries, but the link are broke, is there a way so i can copy the links with the text from excel into access,

Thanks

 

[The_Doc_Man]

Not easily. But I think if you tried to change the format of the Excel column so that it was text and not a hyperlink (or it might be an Excel Options setting to say "no hyperlinks") then you might make better headway.

There is another catch. Unless you have a library that lets you at least read the contents of a .PDF, you aren't going to do much searching within the files. Access doesn't inherently know about .PDFs unless you have a reference to a "wizard" that understands them.