save files from the hard disk into a table in the database

[jutz]

hi,

Please help me how to do this:

I have 3 controls:
textbox - txtFile
command button - cmdSearch
command button - cmdSave

How will I make cmdSearch display (when clicked) a file browser where the contents of my hard drive will be displayed and users will be able to select which file to save. Once the file is selected, the file name (and path) will be displayed on txtFile. Then, when I click cmdSave, I want the file selected to be stored in a table in the database as an ole object. Please help.

Thanks in advance. =)

[kepston]

hi,

Please help me how to do this:

I have 3 controls:
textbox - txtFile
command button - cmdSearch
command button - cmdSave

How will I make cmdSearch display (when clicked) a file browser where the contents of my hard drive will be displayed and users will be able to select which file to save. Once the file is selected, the file name (and path) will be displayed on txtFile. Then, when I click cmdSave, I want the file selected to be stored in a table in the database as an ole object. Please help.

Thanks in advance. =)

You can use Application.FileDialog to provide a dialog box for your user.
If you read the Help files they will tell you about all the different properties, you should then be able to store the file name.

I'm not sure about OLE objects, but I think you can use the txtFile value to link to the file - the field will have to be OLE type

[jutz]

You can use Application.FileDialog to provide a dialog box for your user.
If you read the Help files they will tell you about all the different properties, you should then be able to store the file name.

I'm not sure about OLE objects, but I think you can use the txtFile value to link to the file - the field will have to be OLE type

thanks! =)