468,507 Members | 1,531 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,507 developers. It's quick & easy.

How to import Excel data with one column containing PDF/JPEG files to access 2007?

Hi,

I have beent trying importing Excel data with one column containing PDF/JPEG file name to access 2007.

I have a Excel file with few columns
One of the columns named as "Reference". The data in this is column is in following format.

2009_08_07_16_29_02_Part5.pdf
2009_08_07_16_29_02_Part1.pdf
....

As you can see the column contains ONLY the FILENAME and not the entire path where they are stored.
At the same time, these filenames are hyperlink as well. So when user clicks on these files pdf file opens.

Now i have imported everyother information of this EXCEL sheet. Also the filename is getting imported to access 2007 but they are no longer remain as hyperlink in access.

Now i would like to import all these filenames i.e they should show as filename in access column and when user clicks on it PDF/JPEG file should open.

PS: The field type which is storing this data in access is set as "Hyperlink" type

Any Idea how to accomplish this..

thanks
Prashant
Jul 26 '10 #1
0 1603

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

10 posts views Thread by Niklas | last post: by
3 posts views Thread by gieforce | last post: by
1 post views Thread by fmendoza | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.