Update Access DataBase

<i><b>Originally posted by : gsterle (gsterle)</b></i><br /><br />I am trying to create a script to update an Access database using the contents of a directory listing. That is the access database consists of the file name and the date. I would like to include a column with the full path.<br /><br />invoice1.doc 01/01/00 \svrshfileinvoice1.doc<br />invoice2.doc 01/01/00 \srvshfileinvoice2.doc<br /><br />Any help examples ideas would be appreciated.. i dying here.

<i><b>Originally posted by : Jerry Scannell (JScannell1@home.com)</b></i><br /><br /><br /><br />------------<br />gsterle at 7/31/2000 11:05:20 PM<br /><br /><br />I am trying to create a script to update an Access database using the contents of a directory listing. That is the access database consists of the file name and the date. I would like to include a column with the full path.<br /><br />invoice1.doc 01/01/00 \svrshfileinvoice1.doc<br />invoice2.doc 01/01/00 \srvshfileinvoice2.doc<br /><br />Any help examples ideas would be appreciated.. i dying here.<br /><br />You can determine the file names, date, and path by using File System objects. Any good ASP developer's guide has a chapter that deals with the 'FileSystemObject' via the: <br />set x = Server.CreateObject("Scripting.FileSystemObject")<br /><br />Once you have that, the rest just becomes figuring out which object you want to use.<br /><br />You can then get the collections, objects, methods, and elements that can be easily utilized to provide pathing and file lists for any path. you can then insert the object data into your database table.<br /><br />Good luck.<br /><br />