Make Table from Folder

Question

I have hundreds of jpeg items in a folder on my pc. Fortunately, they have been named in number (from 1 to 3000) according to the primary ID of my parent table. The idea was to simply match a jpeg name with the ID on the parent table.
How can I create a child table that matches the jpeg name with the parent table? I want to avoid the laborious work of dropping each jpeg item into its corresponding place using forms.

Answer 1

I'm confused. You do NOT need to make a table of the image files, I explained this in my first response. You have a table of students, correct? In that Student table is the student ID, correct? That Student ID corresponds to the name of the image file, correct?

If that is the case you do NOT need a separate table to store the locations of the image files. You can use the expression shown to generate the location for the individual student.

Also, you say these images are stored on your hard drive in your users folder. Unless you are the sole user of this app, then the images should be stored on a server folder.

Answer 2

Please show the SQL statement you are using.

But this should work:

SELECT ID, 'C:\Users\gbeng\OneDrive\EMC\Photos\QR500' & ID & '.jpg' AS photopath FROM table;

Answer 3

Try

SELECT ID, 'C:\Users\gbeng\OneDrive\EMC\Photos\QR500' & ID & '.jpg' AS photopath FROM table;

Answer 4

Thanks, Scott.
Your suggestion makes perfect sense. When I tried to run the query however, I got a syntax error. The path to the jpegs is this:
"C:\Users\gbeng\OneDrive\EMC\Photos\QR500". I could not get the syntax right.
Please help again.

Answer 5

I'm not sure I understand. You say; "How can I create a child table that matches the jpeg name with the parent table?", but then you say "Fortunately, they have been named in number (from 1 to 3000) according to the primary ID of my parent table".

So why would you need a child table? It was a smart idea to name each image according to the ID value. By doing so, you have no need to store the JPG's name in your application.

Let's say, you want to display the image on a form bound to the main table. Let's also assume the images are in a folder; C:\Photos. You would add an unbound image control to your form and use the On Current event of the form to run code like:

Me.imgPicture = "C:\Photos" & Me.ID & ".jpg"

You can use similar code to display the images, so I see no reason for a child table.

If you want a list of the photos a query like:

SELECT ID, "C:\Photos" & ID & ".jpg" AS photopath

FROM table;