How to import favorites into Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
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.
Click to expand...
 
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.

John Nurick said:
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.
Click to expand...
Click to expand...
 
Back
Top