Six years ago I built an .asp based site where teachers could upload their lesson plans into an MS Access Database . This was my first site where I utilized a database and while it was my best work at the time in hind-sight I would have done a lot of things differently.
Currently I am developing a .php based site where teachers can upload their lesson plans , but the files will be stored in a directory and the file path will be stored in a sql database that I administer with phpmyadmin 2.10.2.
The problem I am having is that I would like to take all of the files that are stored in the Access database as BLOBs on the first site and save them to a directory for my new site. I think I have figured out how to move some of the database information; I can move author, lesson_name, keywords, file_path, etc, but I cannot figure out how to get all of the files stored as BLOBs out of Access and into a directory. Currently the only way I have of doing this is going to my site an where all of the files are displayed and I can save them one by one and rename them, but there has to be a better way, an automated way to deal with over 1700 files. I tried DB Blob Editor and MS Access Extract Images, but with no luck.
The actual database is too large to email so I have attached a copy of the database with only 10 records in it so that you can see the structure and layout. My server blocks .mdb file attachments so you will have to rename the attached file with the .mdb extension. The table is fairly intuitive, but&
File Name = The name of the file they uploaded
File Size = Numeric file size
File Data = The Long Binary Data, the actual file
Content Type = The type of file
Type of File = Either a lesson plan, test, quiz, etc&
Any help would be appreciated..