How to import favorites into Access 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mangomama - 22 May 2005 23:05 GMT

Is it possible to import favorites from IE and create a data base?

Reply to this Message

John Nurick - 23 May 2005 07:05 GMT

The capability isn't built into Access but it's possible with a bit of
work. One way would be to export the bookmarks from IE to an htm file
and write code to parse the HTML into something that Access can import.
But before going to that trouble, search at groups.google.com for (e.g.)

"internet explorer" bookmarks access database export OR import

and you'll probably find something that will do it for you.

>Is it possible to import favorites from IE and create a data base?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

Douglas J. Steele - 23 May 2005 12:52 GMT

Actually, there's no HTML to parse with IE bookmarks, John: the bookmark is
like an INI file. For instance, here's the content of my shortcut to MSDN
Advanced Search:

[DEFAULT]
BASEURL=http://search.microsoft.com/search/search.aspx?view=msdn&st=a&c=0&s=1
[InternetShortcut]
URL=http://search.microsoft.com/search/search.aspx?view=msdn&st=a&c=0&s=1
Modified=C0AF2FD4C037C4012E

I haven't tested, but you should be able to Dir to retrieve the bookmarks
(the file extension is .url), and then use GetPrivateProfileString to read
it.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> The capability isn't built into Access but it's possible with a bit of
> work. One way would be to export the bookmarks from IE to an htm file
[quoted text clipped - 11 lines]
>
> Please respond in the newgroup and not by email.

Reply to this Message

John Nurick - 23 May 2005 22:39 GMT

That's much too simple, Doug! I was looking at the HTML (or near-HTML)
file you get when you export favourites from IE.

>Actually, there's no HTML to parse with IE bookmarks, John: the bookmark is
>like an INI file. For instance, here's the content of my shortcut to MSDN
[quoted text clipped - 9 lines]
>(the file extension is .url), and then use GetPrivateProfileString to read
>it.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

Olivier Crouzet - 01 Oct 2005 18:16 GMT

Should work fine, no doubt, but you would have to cope with as many ini or
txt files as favorites entries, or have I missed the point ?
Maybe we could have a look at Netscape, if I remember well it aggregates
favorites into a sole file (txt or html?)
Well nothing against IE, just a reminiscence (and nostalgy) of what was the
first internet browser ever.
Strange, there is not even a conversion tool though there are so many
dedicated to mail address migration.
Maybe part of next Office Suite (12)?

Please post in the newgroup.

> That's much too simple, Doug! I was looking at the HTML (or near-HTML)
> file you get when you export favourites from IE.
[quoted text clipped - 17 lines]
>
> Please respond in the newgroup and not by email.

Reply to this Message