Import/Link Sharepoint files into Access 2007

[JamesDSM50328]

I am trying to link/import documents (txt) from sharepoint to Access 2007 as an access table. The Sharepoint list shows all the documents in the folder and the name of the document is a hyperlink, which i can extact the address. How can I then Link or import the document to access?

The docmd.transfertext does not seem to work.

 DoCmd.TransferText acImportDelim, , "mytable", "[URL unfurl="true"]http://address/folder/file.txt",[/URL] True

 

[Remou]

This may be of interest:

http://msdn.microsoft.com/en-us/library/aa159897(office.11).aspx

http://lessthandot.com