How do I import file and path names of images into access

[src2]

First of all I'm not sure if this is the proper group to ask my question so if it's not my apologies in advance.

What I'm trying to do is create a database for a single user to display product information (product name, price, etc and product image) on a form. The method I want to use is to store the images as external files storing the file name, path etc, in the database. The file name is being used as the product name. There are several examples of how to do this so that part shouldn't be a problem. What I don't know how to do is import the filename and path of existing images (over 1000) without entering each one manually. Also at a later time add additional images to the existing table.

One other thing I need help with is I receive a price list in excel that contains the product name and a price. I'd like to be able to point to this file and update the prices for existing products or add them if they do not already exist.

I know this is a lot to ask but any help would be greatly appreciated.

Thanks

 

[Remou]

You can use Application.FileSearch

http://msdn.microsoft.com/library/d.../vbaof11/html/ofobjFileSearch1_HV05221253.asp

To find the files you need and append then to a table: a recordset is probably easiest. Transfer spreadsheet will allow you to import the spreadsheet and from there a few queries can be used to update the tables. Alternatively, you can link to a spreadsheet.

 

[dashusa]

its very easy to import an excell file so you might want to save the image names in an excell file and then import it in to the database once it is in the you can use find and replace to change the img path to how it needs to be in order for you to be able to display it later...