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

Again, show us exactly what you used. And how you used it. We can't see what you see.

Answer 3

https://www.52pojie.cn/thread-1785783-1-1.html

if you want to reclassify the images directly ftom file system,please take a look at above post for your reference.

Answer 4

When I use it as you have suggested, I get "Syntax error in FROM clause."

The files in the folder are named X.jpeg, where X is an integer.

https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-find-accessexe/709367ec-a936-4460-afbc-6a45ea20afdc?page=3

I am afraid you have not imported .jpg files name to the table.

1.

dir /b *.jpg >1.txt

2.

then open 1.txt with excel and copy and paste to table_my_jpg to Access

3.

select * from table_my_jpg

Answer 5

When I use it as you have suggested, I get "Syntax error in FROM clause."

The files in the folder are named X.jpeg, where X is an integer.