Importing or Uploading file

[avagodro]

I work for a hospitality company. Regularly, our Quality Assurance Department "shops" one of our various properties, records the call, and grades them on several predefined "points".
I have created the database which is used to enter the information from the call: Property, who "shopped" them, Date and Time, then the points required. This is all working fine.
What I would like to do now is be able to let them "attach" their calls, which are in a .wmf format on each of their individual hard drives. The attached files can either be imported into a separate database or copied to a subdirectory under the current "shop" database. The database is stored on a network drive.
Any suggestions?

 

[Crowley16]

the easiest way is to store the files with a set name format in a pre-determined location, and then just store the path of the file, as text, in your db...

you can infact include ole objects in your db, but this does tend to bloat things and are generally more work than necessary...

--------------------
Procrastinate Now!

 

[avagodro]

That is basically what I am looking to do. Does anyone have any information on how to go about doing this?

 

[BuilderSpec]

Create a table that is linked to your master table..

Possible fields are

WMFID AutoNumber
ShopID Number - Links to main file
WMFPath Text - Contains full path of wmf file