move file quesion

[daveofgv]

I am going to need to create a windows form for work that we can connect to a database table, select a directory and move files from the directory that are in the table and move to another folder.

The directory will have sub directories that I need to search for the file name and move.

I would like to have the table hold the file name (or path) and move all files that are in the database. There might be 20 files or 1000. Depends on the client we are processing for.

Example: User selects the directory - then clicks a button to move each file in the database.

Is this easy and possible?

this can also be in VB6 (which ever is easier)
thanks in advance

daveofgv

 

[JohnH]

System.IO Namespace () File class and Directory class is most relevant for you.

You also have this: My.Computer.FileSystem Object - methods here can provide UI also.

 

[daveofgv]

I get the move file portion, however, here's what I will have...........

I will have a excel sheet with a column of a bunch of file names (images) (example....... 3435534334.tif). I have all the images in 20 or so folders within one directory.

I will need to make the simplest program possible to retrieve only the images names on the spread sheet and copy those images into another folder. I then need the program to write to text file the images that it didn't copy.

I need this to be the simplest, since we are hiring temp workers that really don't know anything about computers.

Right now, I have 2 FolderBrowserDialog's which provide the directory path into 2 textbox's. I know how to copy all the files or even some files. I just don't understand how to copy the files/images that are in a spread sheet (or I can even import the spread sheet into a datagrid (access) and keep that as my reference.

Any suggestions?

Thanks
daveofgv

 

[JohnH]

You can read the Excel file either using the Microsoft Excel Object Library for automation, or using the OleDb data provider in ADO.Net to load data into a DataTable. It shouldn't be hard to find examples of both from a web search.