exporting from excel to access

[Victorlabinsky]

I am not a programmer, but I figured a way to hyperlink in excel, but when I exported it into access the links did not work. Now I work with hundred thousand files, the code I wrote in excel was: =HYPERLINK("F:\County\Digital\01445\" &D & ".001.tif","Link")
I used this code because 01445 stands for volume number, the latter part of the code lets me number the pages automatically, but since the documents that are linked are multiple pages it goes to the first page only which is .001.tif, the "Link" renames the address as link. I really do not need to rename it link but the problem I have is that I have that same document that goes to multiple entries. I put an example on the bottom. As you can see I tell excel to look in the folder "digital" for the volume number and then it looks for the "document number" and adds .001.tif to it so it goes to the first page of the document. How can I put a code in one column that I can transfer into access and make the whole column a hyperlink. I work with county records which could amount to over a million records??? HELP!!! Please do not forget I am not a programmer so Please put in plain english.
Thank you



Vic
field I would have are:
Link, Doc Number,State, County, Sequence, Grantor, Grantee, Document Type, Book, Volume, Page, File Date, Time, Instrument Date, Reference

 

[SBWolfe54]

When you import data from Excel, you will have the opportunity to specify information about each field you are importing from the spreadsheet. You first have to tell ACCESS that you have field names in the first row of the spreadsheet. These would be the fields you have described in your request. When it comes to the step about specifying information about each field, you can either let ACCESS determine the field type or you can select it from a drop down box. Hyperlink is an option from the drop down box.

Thanks

 

[Victorlabinsky]

That did not work, since the code I wrote was for excel, and when I told access to create that column into hyperlinks it still went no where. The link I use in excel is not for the internet but to a file in my computer. Thanks anyway.