Question Export Rows into individual text files?

[Pat Hartman]

MakeDir() is a function jdaw created that wraps around the intrinsic VBA function which is MkDir(). The function jdaw created displays a message every time it creates a directory so if you use that, you should probably comment out the msgbox function unless you want to keep saying OK for every directory.

When you call a function, the arguments are enclosed in parentheses so your code should be MakeDir("C", sDirBase & Format(iFolderCount, "0000")) but you need to copy the function jdaw posted and paste it into a standard code module. You'll know you got it right if when you type MakeDir( you'll get intellisense help for the arguments. Same with the standard MkDir() function.

 

[RCesto]

I just wanted to hop on and thank everyone for there help. Its still choking up for whatever reason after creating the 1st txt file before copying the records into it but i'm sure its something dumb that I either accidentally changed on my end or don't realize I have to change. Thanks Pat and JDraw for your help.

 

[jdraw]

The sample function I gave in post #20 is a working example.
I named my table to match yours.

Check your logic against what I posted.
Good luck.

If you have specific error/sample/question, please post.

ALSO: As Pat said you can comment out the msgbox in the MakeDir procedure to avoid responding to the msg.

 

[gemma-the-husky]

out of interest - although this can be done, what are you trying to do it for?

a common alternative is rather than store the text IN the database, is to store the file normally, and just provide a link to the file on the hard drive.

 

[RCesto]

And it WORKS! Thanks you everyone. Hopefully i'l be able to help some people out at a later date what I have a better grasp of what's going on.