Loading files with a D00 file extension into access

[drbtodd1971]

I'm writing a database which pulls in data from another third party sql server database. All works fine except for one thing, I have picture files which are saved as DIB (Device Independant Bitmap) but have the file extension D00. They are actually Jpegs but are saved as D00 files to save space I believe. I have no control over them being saved that way as that's the way the third party software saves it.

I can't load them into access as it comes up as "Invalid File format", I've got round this by changing the file extension of them to jpg in another directory. This is fine whilst I'm testing but will be a pain soon when there are thousands of them. Is there a way I can load them into access without having to change the file extension, as in principle they are jpeg files but with a different extension?

 

[Ed2020]

One way would be to use Application.FileSearch to build a file listing of all the files in the directory and then iterate through each file and use Name As to change the file extenstion to .jpg.

Ed Metcalfe.

Please do not feed the trolls.....

 

[fneily]

You shouldn't save pictures in Access. The database will quickly become HUGE. And if there will be "thousands", you're shooting yourself. You save the path name to the file. Do a search on images in these Access forums to see more info on it.

 

[drbtodd1971]

I'm storing my pictures in files in a directory on the server and they are being named after the id number, all I want to do is display the relevant picture in the database. The pictures aren't physcially stored on the database they are simply retrieved from the file when the relevant id is selected.