I have about 300 photos that I need to insert into Access. All the photos are .jpeg's, but Access requires a .bmp. Is there a way to change the file extensions for all of these files at once?
Well, No if you are intentending to change only the file extension. (which you can do in Explorer, but please read on)
The problem is that .bmp and .jpg are fundamentally different file formats. What you need is a .bmp to .jpg batch conversion program.
There are several, including I believe some you can use under their Trial license, or possibly some freeware ones.
To research what is available, do a Google Web search on the key "bmp to jpg batch file conversion" and I suspect you will quickly find your answer.
thanks for the response. I don't need to convert the files, because changing the file extension allows the file to be iserted into Access. I found a program called NameWiz that allowed me to manipulate all of the file names at once. I will try the command prompt, sounds a lot easier.
Thanks, Freestone, your advice was a great help in a rather similar problem. My difficulty was that I had a load of test output sent to a 'generic printer', which meant that files were created without an extension.
I also didn't know how to get to a director in MS DOS - my history is Mainframes, Apple Mac and Windowns 3.1. For the benefit of those with similar histories, I'll post the whole process:
Code:
> c:
> cd my_place
> ren *.* *.txt
Note that this changes every file in the directory called my_place that was on my C drive. To be more selective, you'd need something like Freestone's ren *.jpeg *.bmp
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.