Import Hyperlink into ACCESS from EXCEL

G

Guest

I inherited a EXCEL worksheet with thousands of hyperlinks. I would like to
import the worksheet into an ACCESS table. I tried many different methods,
but I have not succeeded in importing the worksheet into ACCESS. I tired to
deactivate the EXCEL hyperlinks(right click, hyperlink, deactivate) but it
seems that I can only deactivate one cell at a time - as opposed to
highlighting the entire column and deactivating all the hyperlinks at once.
Would you know of a method to import the EXCEL worksheet into ACCESS. I would
like to preserve the hyperlink from EXCEL so that it can be activated in
ACCESS.
Thank you
 
P

Paul

Have you tried saving the spreadsheet as delimited text as suggested
previously?

--
Michael Badnarik for President '04
Libertarian...the freedom party
www.lp.org
www.badnarik.org

"If you are in prison and your chances are 50% for execution by electric
chair, 45% for execution by lethal injection, and 5% for escape, are you
just going to vote for the chair because it is the likeliest outcome?" Vote
Libertarian and live to be free.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Hyperlink 1
Import Excel Table Hyperlink to Acces 2003 3
Import hyperlink from EXCEL 1
How can I import an unstandard Excel worksheet into Access 2007? 3
Hyperlink to Explorer 5
import multiple Excel worksheet into a main Access table 1
Import data from Access to Excel containing VB code 3
Import hyperlinks 2

Top