Hyperlink not working in sql server

• park1432

  SSC Veteran

  Points: 259

  More actions

  May 3, 2012 at 8:07 pm

  #260974

  I am working on migrating data from access to sql server by using sql server migration assistant for access and this wizard migrated hyperlink twice

  i.e #C:\Users\Health\Desktop\SQL\1-29-12#C:\Users\Health\Desktop\SQL\1-29-12# for single record in most of the rows.

  Any solution for this will be really appreciated.

• vinu512

  SSCoach

  Points: 15729

  More actions

  May 3, 2012 at 11:37 pm

  #1483402

  I don't know about the tool you are using....but you can do it easily by using either of the following in SQL Server:

  1. Import/Export Wizard

  2. Bulk Insert

  Vinu Vijayan

  For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉