import csv from .zip file

[Guest_imported]

I currently have a procedure to import text files into my db. The spreadsheets are getting huge, so the client sends them zipped. Anyone know script to unzip a file then import into access.

I'm trying to build a form so a receptionist can do the import.

thanks

 

[DougP]

Not sure if this will help
But WinZIP can be run from the Access Shell command
like so

Dim x As Variant
Dim filename, folder As String
filename = "C:\Program Files\Winzip\example.zip"
folder = "C:\Test123"
x = Shell("C:\Program Files\Winzip\WINZIP32.EXE -e -o " & filename & folder, 1)

I did not get it to work correctly... Ran out of time

here is a list of parameters on thier WEB site

http://www.winzip.com/xcmdline.htm

DougP, MCP