dbTalk Databases Forums  

Using MKDir

comp.databases.ms-access comp.databases.ms-access


Discuss Using MKDir in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
bezz
 
Posts: n/a

Default Using MKDir - 03-06-2011 , 06:33 AM






Is it viable to use MKdir with a table such that you can use something like folderprint to export a table of
filenames (books with author in the filename for example) and use mkdir to loop through and create a filename
with the authors name as title? I suppose it should be possible to do this with running a loop until EOF
that steps through the taable, setting path as a string variable, and adding the current record to it, then
using the MKdir function create a new entry...?

Thanks JBN



--
--------------------------------- --- -- -
Posted with NewsLeecher v4.0 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

Reply With Quote
  #2  
Old   
David-W-Fenton
 
Posts: n/a

Default Re: Using MKDir - 03-07-2011 , 01:53 PM






bezz <bezz (AT) sumwhere (DOT) com> wrote in
news:geKdnUWoRu284u7QnZ2dnUVZ8lCdnZ2d (AT) giganews (DOT) com:

Quote:
Is it viable to use MKdir with a table such that you can use
something like folderprint
What is "folderprint"?

Quote:
to export a table of
filenames (books with author in the filename for example) and use
mkdir to loop through and create a filename with the authors name
as title? I suppose it should be possible to do this with running
a loop until EOF that steps through the taable, setting path as a
string variable, and adding the current record to it, then using
the MKdir function create a new entry...?
Yes, but you'd have to check whether the folder already exists. For
empty folders, this is hard with Dir(), so I'd recommend doing it
with the File System Object, which is more capable on all of this.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

Reply With Quote
  #3  
Old   
bezz
 
Posts: n/a

Default Re: Using MKDir - 03-07-2011 , 02:35 PM



Folderprint is a utility that you can scan folders/files in and export them to Excel, delimited txt files,
csv etc. You can read it into excel and delimit to split author/title, artist/album etc and then base a
table on it to do mkdir.

I used a DAO recordset routine, read the author name, added it to a pathstring and created the folder.
Useful little routine that could be tweaked quite easily, but as you say, needs a check to see if the dir
exists for completeness.

J


--
--------------------------------- --- -- -
Posted with NewsLeecher v4.0 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.