• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Importing Hyperlinks into Access

I imported a list filled with hyperlinks into an Access table, but none of my hyperlinks work properly. What happened?

When you create a table by importing data, Access automatically recognizes a column that contains URLs or UNC-style file addresses and uses the Hyperlink data type for that column. However, this conversion takes place only if all the values start with a recognized prefix, such as http: or \\. If even one value doesn't follow this format, Access refuses to convert the column into a Hyperlink field. Switch to Design view and change the data type for the field to Hyperlink; after you save this change, all your hyperlinks will work properly.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint