Import CSV file that is currently zipped

wolff1215

I have a CSV file that is downloaded twice a day.
The file comes zipped (And they won't change it for me)

Is it possible to open the Zipfile and a import the file contained with
in it?

(I'll have the user browse to the Zip file, then my code should open
the zip and pull out the CSV file)

I want to use VBA to open the CSV file and then add it to a recordset
once I have ran a few functions on it.

Thanks in advance for any help.

Nov 13 '05 #1

Subscribe Reply

4133

Salad

wo*******@yahoo .com wrote:

I have a CSV file that is downloaded twice a day.
The file comes zipped (And they won't change it for me)

Is it possible to open the Zipfile and a import the file contained with
in it?

(I'll have the user browse to the Zip file, then my code should open
the zip and pull out the CSV file)

I want to use VBA to open the CSV file and then add it to a recordset
once I have ran a few functions on it.

Thanks in advance for any help.

Check out the Shell function. You can also check out
http://www.mvps.org/access for API functions. One of them opens the
application file based on the associated extension.

You might want to make this a 2 step process. Create a command button
to do a FileOpen and get the zip file name. (see API functions at web
link http://www.mvps.org/access for FileOpen dialog box). Once found,
run the API call to open the Zip or Shell function. Then press a
command button to import.

You may be able to automate it more based on your naming schemes of the
zip and csv file. I don't know if you are overwriting the same zip file
name each time or opening the zip file with the rest of the CSV and csv
files.

Nov 13 '05 #2

Similar topics

2473

would be nice: import from archive

by: Dan Perl | last post by:

Here is a python feature that I would like: to be able to import modules from an archive like the jar files in Java. Maybe a regular tar file? Maybe a python specific file type, let's call it a 'par' file? It would be useful in packaging an python library. Sure, there's always the python packages, but a single file instead of a whole...

Python

3065

File Import Wizard

by: David Berry | last post by:

Hi All. I'm looking for any help or sample code that can show me how to make a file import wizard in ASP.NET (VB preferred) like the one that MS Access uses. I'm working on a web site where the user has the ability to upload a file (.txt or .csv). The data in the file may be comma delaminated, tab delaminated, fixed width etc (we don't know). ...

.NET Framework

1727

Help--My Array is too Big-----Help move to a .dat file?

by: Yogi_Bear_79 | last post by:

Visual Studio .NET started complaing when the array was around 4000. I found that if I pasted the array in via notepad then opened Visual Studio it would work. Now my array is over 26,000 and Visual Studio just doesn't like it. Everytime I open the prokect I get the following error: "An Error occurred which the C# comipler is unable to...

C# / C Sharp

4501

Is it possible to embed a zipped text file, then unzip or read from it at runtime?

by: Yogi_Bear_79 | last post by:

pardon my ignorance as I am a self-taught hobbyist programmer. I am curious after reading up on SharpZipLib. Can I embed a zipped txt file in my program? Then either read from within the zip file or unzip and read it? I currently have an embedded text file that contains a list that is read into an array. I'm always looking to save...

C# / C Sharp

2466

Want to unzip a partial zipped text CSV file

by: johnnyh | last post by:

I am currently using ASP.Net / C# to partially upload the first 100K of a CSV file to programattically extract the header information for field mapping against our database and for a test sample of records to check some validation before entire file is uploaded. (Files can be HUGE) Question - what about when the file is Zipped? Can I...

C# / C Sharp

2528

many excel files import to One Table in Access

by: amy | last post by:

Hi, all: i am a new end user of access, now I have many excel files need to import to One table in access (combine all excel files into one table in excel). In excel files, some columns will have both # and text in the same column. The coloumn names in each excel file are mostly same but still a lot of different names(items). I was told to...

Microsoft Access / VBA

11804

Import Excel data with .NET

by: Niklas | last post by:

Hi Before I start coding I need to be sure that nobody else has not done it yet and that I can use it. I need an import utility which import data from Excel to a database or some object in .NET. The data in Excel is not in structured columns but can exist everywhere in the workbook. For example if I am supposed to import a person and all...

C# / C Sharp

3917

Using a Process to Extract a file from Winzip archive

by: learningvbnet | last post by:

Hi, I am trying to extract zipped files using Winzip in my VB.net application and I ran into 2 stone walls. 1. How do you handle file names with spaces. See psiProcess.Arguments For example "My Data file Apr2007.zip"? In the example below, the parameter pZippedFile contains the file name with spaces and the ...

.NET Framework

1459

retrieving a zipped file from a database

by: 7seven7 | last post by:

Once i zipped my file a simple .xls spread sheet i write it to a database ... evoking the toArray() method of the memory stream, however now trying to recover this zipped file it doesn't display the zip within. My question is this how will i get the zipped file to show

Visual Basic .NET

7659

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7580

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7882

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

7634

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

5208

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3634

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

2079

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1194

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

916

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General