How do I read the a disc and put results in DB?

[drruth2]

Have a multimedia DB. Wish to "read" structure from disc and put into DB
table(s). Will also be able to manually enter data from sources that can't
be "read" such VCR tapes.

 

[Larry Linson]

Have a multimedia DB. Wish to "read" structure from
disc and put into DB table(s). Will also be able to
manually enter data from sources that can't
be "read" such VCR tapes.

That would, I suppose, depend on what you mean by "structure" and what kind
of "disc". There are I/O instructions in Visual Basic for Applications code
that will read disks... hard drives, floppies, and at least some CD / DVD.
But, it's all a matter of the data format on the disk and your reader
machinery. You can certainly, easily, create a user interface to expedite
typing in information that your user obtains by other means.

The memory card from my digicam appears as a disk, so I can read / copy /
delete files from that, so it may well be that audio and/or video disks
appear the same as a computer disk and can also be read -- but you may or
may not be able to extract things like name of the song or movie, etc.

Larry Linson
Microsoft Office Access MVP

 

[a a r o n . k e m p f]

this is all I need to do to get this info into a database

xp_cmdshell 'dir e:\ /s'

you can use the insert exec statement to store it into a table
automagically

insert results
xp_cmdshell 'dir e:\ /s'

 

[a a r o n . k e m p f]

btw, is this.. uh.. you live in bothell?

give me a call sometime, do you not talk to marty anymore??

-Aaron

 

[George Hepworth]

Dude, you do realize that "automagically" is a made-up word , don't you? You
do understand that magic is NOT a part of the SQL Server database, don't
you?

The term, "automagic" was, in fact, created by a marketing department in a
manufacturing company to sell small appliances to housewives in the 1940's
and 1950's--folks who MIGHT have been impressed by the thought of magic
making their jobs easier.

The term was, apparently, picked up by "software types" who don't really
understand how things work. Some of them, therefore, refer to such things as
"automagic" because it's beyond their ability to understand, just like real
"magic".

Once again, I am urging you to take some time away from the forums and try
to figure out how to address questions like this with appropriate, relevant
and, above all, coherent, responses. It will do you a world of good to just
get away for a while. Forget all about the stress and frustration of
constantly embarrassing yourself in public, and maybe even concentrate on
some personal activities that will help you get a better perspective on
life.

Give it a rest, Dude. Give YOURSELF a break. You'll come back refreshed and
happier.

Best of luck to you.



message
this is all I need to do to get this info into a database

xp_cmdshell 'dir e:\ /s'

you can use the insert exec statement to store it into a table
automagically

insert results
xp_cmdshell 'dir e:\ /s'

 

[Trek]

Which version of SQL server you would recommend to store directory listings.

I guess the Enterprise version would be appropriate and he could buy some
fine hardware.
It should not cost more then 30 000 USD. Is it OK?


"a a r o n . k e m p f @ g m a i l . c o m" <[email protected]> píse v
diskusním príspevku
this is all I need to do to get this info into a database

xp_cmdshell 'dir e:\ /s'

you can use the insert exec statement to store it into a table
automagically

insert results
xp_cmdshell 'dir e:\ /s'