Zip storaGE/ DaTa BAsE

[PAPA--]

(this is a repost )
I will skip the basic intro of "Hi im new to access and i dont know.."
anyways, what I am trying to search for and I dont know what Im looking for is this.

Q1) I would like to be able to open a zip file, read the NFO/txt file from within and import certain areas of the NFO file,the NFO file of course is layed out with ascii art but there is a predetermined area where certain info is obtained. for example: I would like to capture/import the URL, testers name, date avaliable, zip file name.THEN the text imported would be written to the database. It would be nice to figure out how you go about importing certain lines but im not sure how to ask the question and find the answer the right way. ie...(ascii art found here http://www.ascii-art.de/)
-= I did search import text and get text and didnt find what I was looking for=-

Q2) How do I write to an ascii file/nfo/txt using access, there is a template or a layout that is pre done,and i need certain fields filled out, just like they above layout.

thanks for all your help, you guys are awsome, and keep up the good work!

 

[PAPA--]

aM I missing something?
or am i on ignore

 

[Mile-O]

What is an NFO file?

 

[PAPA--]

From Wikipedia, the free encyclopedia.

NFO is an abbreviation of "info", which is shorthand for information. It is used as a three-letter filename extension in 8.3 file systems. Files with the NFO filename extension most commonly appear as generic ASCII text files designed to be viewed with a text editor or specially designed NFO viewers. Less commonly, in Microsoft Windows, a file with an NFO filename extension is handled by a Microsoft software tool called System Information (by default).

-=You actually set up a text editor to open this by default=-
the art would have info inside of it like for example...

.--..--..--..--..--..--.
.' \ (`._ (_) _ \
.' | '._) (_) |
\ _.')\ .----..---. /
|(_.' | / .-\-. \ |
\ 0| | ( O| O) | o|
| _ | .--.____.'._.-. |
\ (_) | o -` .-` |
-=special info=-
| \ |`-._ _ _ _ _\ /
\ | | `. |_||_| |
| o | \_ \ | -. .-.
|.-. \ `--..-' O | `.`-' .'
_.' .' | `-.-' /-.__ ' .-'
.' `-.` '.|='=.='=.='=.='=|._/_ `-'.'
`-._ `. |________/\_____| `-.'
.' ).| '=' '='\/ '=' |
`._.` '---------------'
//___\ //___\
|| ||
||_.-. ||_.-.
(_.--__) (_.--__)
anyways, i was just wondering if I wanted to import " special info" above how would i figure out what lines to import? does access
have a (x) and location to import, specfic lines of info, and the ascii art has many diffrent charcters to draw with. And i would love to just stick with access instead of using something else to filter the NFO file.

thanks a million!

 

[ScottGem]

First NFO is by no means a standard naming convention. In fact, DAT or TXT are much more common extensions for such files.

Second, to be able to open a zip file and extract a file from within it you would need a command line interface to ZIP files. WinZIP has such an interface for a fee. You could then use the Shell command to run this.

Finally, you would use the Open and Line Input commands within Access to read the file line by line and then parse each line depending on its format.

 

[PAPA--]

k, is there a way to automatically(magic button theroy) import specific words or phrases from a TXT file located in a ZIP file, and saved to a table without physically opening the zip file, opening up the txt file and then deciding what to import? And please remember im dumb
so a long drawn out in you "face" answer would ROCK!!!


thanks a million!

 

[ScottGem]

k, is there a way to automatically(magic button theroy) import specific words or phrases from a TXT file located in a ZIP file, and saved to a table without physically opening the zip file, opening up the txt file and then deciding what to import? And please remember im dumb
so a long drawn out in you "face" answer would ROCK!!!


thanks a million!

No. You can't import anything without opening the file.