How to import favorites into Access 2003

[mangomama]

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

 

[John Nurick]

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.

 

[Douglas J. Steele]

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.

 

[John Nurick]

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
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.

 

[Olivier Crouzet]

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.

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.