Extract WinXP file info fields into Access BD

  • Thread starter Thread starter mettá
  • Start date Start date
M

mettá

I am trying to find a way to extract WinXP file (mpg) information fields
into a db but have no idea how to do this??

The specific file fields are
"Title","Author","Comments","Subject","Category","Source"

Is there a way to extract this data (Around 500 video files, 90% of which
have the above fields completed) and put it into an Access DB

Thanks
M

--
 
Steve said:
Just a guess ........

Have you tried Notepad?

Steve
Click to expand...

Have you considered getting a REAL job? Your constant trolling for work is
getting a bit monotonous.

John... Visio MVP
 
If you can find the file-format for the .mpeg files, you may well be able to
use Access File I/O in binary mode to read the data. It's very flexible, but
does require some VBA programming knowledge, and, as I said, a knowledge of
the file format. Back in the "long-ago but not-so-far-away" (late 1980s /
very early 1990s) there was a two volume set on "common file formats", but
when I used those books, I am not sure the Motion Picture Experts group had
defined the .mpeg file format. I was using them to decipher some DOS file
formats for translation into other DOS file formats or text. (You aren't
going to press me for the exact name and author of something I used nearly
20 years ago, now, are you? Google is your friend on this one.)

You could use the Dir function to retrieve the file names (it's reasonably
well-documented in VBA Help, accessible from the Module window. You can DO
and LOOP until continued execution of the Dir does not return a file. Start
your research on File I/O for this purpose with the Open statement, file
type binary, and follow where the help and discussions lead you. I'll have
to admit that both Access 2.0 and Access 97 had better documentation on File
I/O than current Help, but my "gut feel" is that the current help and online
searching is more than enough tutorial, certainly so if you've had any
programmer training.

Larry Linson
Microsoft Office Access MVP
 
Back
Top