Move Excel file to specified folder after importing to Access Tabl

  • Thread starter BTU_needs_assistance_43
  • Start date
B

BTU_needs_assistance_43

Can it be done? I want my program to search for all Excels files which it
does using the .FileSearch command, but once its done, can I write anything
into so that it will take the file it just read and move it into another
folder so that it will be out of the folder I do my searches in so that it
won't be added to the database multiple times?
 
D

Dale_Fye via AccessMonster.com

Take a look at the FileCopy statement. The way I would use this is to copy
the file to the new location.

I would then test to make sure that the copy actually worked using the Dir()
function.

Finally, I would use the kill statement to delete the file from the original
folder.

HTH
Dale
 
Top