[thelist] Directory Structure into Access

[Ken Schaefer]

-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of VOLKAN ÖZÇELIK
Sent: Friday, 24 February 2006 2:53 AM
To: thelist at lists.evolt.org
Subject: Re: [thelist] Directory Structure into Access

>> That said, is there a way to poll the directory, grab 
>> all the files and drop them into the database via a 
>> script or macro or some other method?  This is all 
>> running locally, so there are currently no webservices 
>> behind it to help me along.  I'm a relative novice here, 
>> so the simpler the solution, the better.
>
> You don't need a web service. You can write a simple application in
> your programming language of choice (preferably in c# or java) that
> traverses file system and inserts into the database using sqlcommand
> object or something similar.
> 
> I think it can be done with a VB macro of some sort in access as well.
> However it has been a long time I haven't written macros so
> unfortunately I don't remember much to help you.
 
You could do this entirely within Access using a Module and the File System
Object. Then create a form with a button. Clicking the button would kick off
the module.

Cheers
Ken