Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have the following data in an excel..The file path is pointing to where the images are palced. But I'm not able to view these images in Access point. it is blank. Any ideas why it is not hswing iamges
Region | Unit | Year | Folder | FileName | FilePath |
America | Power | 2011 | ..\..\Data\ |
| ..\..\Data\ABC.JPG |
America | Power | 2011 | ..\..\Data\ |
| ..\..\Data\XYZ.JPG |
America | Power | 2011 | ..\..\Data\ |
| ..\..\Data\FED.jpg |
LOAD
Region,
BusinessUnit,
Year,
Folder,
FileName,
FilePath
FROM
[..\..\Data\Ref.xls]
(biff, embedded labels, table is IMGLocation$);
Regarsd,
john
hi,
Is the issue when accessing over the web from different machine ? if yes then you mighthave to share the pics and give the share path like below
\\Servername\folder\image.
Deepak
hi,
Is the issue when accessing over the web from different machine ? if yes then you mighthave to share the pics and give the share path like below
\\Servername\folder\image.
Deepak
Hi Deepak,
yes..you are right..I can see these on my laptop...but when I post it to a server with a similiar folder structure as my laptop..and access it using web..cannot see it.
Where do I need to do these changes..in the script or in the excel source file?
Regards,
John.
Thanks Deepak...putting the actual path in the source file instead of the relative fixed it.