Importing Excel Data with Hyperlinks

  • Thread starter Thread starter MWE
  • Start date Start date
M

MWE

I am importing data from an Excel2000 worksheet into an
Access2000 table. Any Excel data hyperlinks are in a
special Excel column corresponding to the Access column
with type set to hyperlink. When the import is completed,
Access understands that certain table cells have
hyperlinks but the underlying URL info is missing.

Can the complete hyperlink with associated URL info be
imported into Access?
 
See my message in the thread "Import data with hyperlinks" in this
newsgroup on 1 December.
 
I can't find the related reply, John..you might want to
post an answer. Thanks!
-----Original Message-----
See my message in the thread "Import data with hyperlinks" in this
newsgroup on 1 December.

I am importing data from an Excel2000 worksheet into an
Access2000 table. Any Excel data hyperlinks are in a
special Excel column corresponding to the Access column
with type set to hyperlink. When the import is completed,
Access understands that certain table cells have
hyperlinks but the underlying URL info is missing.

Can the complete hyperlink with associated URL info be
imported into Access?
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
Search for it at http://groups.google.com/advanced_group_search?hl=en

I can't find the related reply, John..you might want to
post an answer. Thanks!
-----Original Message-----
See my message in the thread "Import data with hyperlinks" in this
newsgroup on 1 December.

I am importing data from an Excel2000 worksheet into an
Access2000 table. Any Excel data hyperlinks are in a
special Excel column corresponding to the Access column
with type set to hyperlink. When the import is completed,
Access understands that certain table cells have
hyperlinks but the underlying URL info is missing.

Can the complete hyperlink with associated URL info be
imported into Access?
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
Click to expand...
 
Back
Top