Can anyone suggest VB code, or a method of exporting the contents of a

1 - zip file, and

2 - directory

to a database table, xls, or file?

Thanks in advance.

Larry Mehl

Dear Mr. Mehl,

        Well it's an old Kludge yet it may get you there, I used it to manage
hardrive filing system w/ access. Shell32 and wait a pkzip -v piped to a
text file. Then you will need some code to read in and process your text
file.

del "arch.txt"
iRV = Shell("pkunzip -v arch.zip > arch.txt", 1)  
' there is a way to shell & wait, but I'd have to charge ya for it.
do
        wait (2)        
 until fileexists("arch.txt")
' read in the file and populate tables
open #4 arch.txt for input
        blah blah blah
close #4

HTH,
Byron
=========================================
| Downey Enterprises          (414) 654-3555
| Opening Information for your Organization
| P.O. Box 264, Kenosha, WI    53141-0264

=========================================