Help.........

I have a CDROM that has address information from the USPS.

If you have any source code for this I would appreciate it.

What I want to do is pull the address and zip code from the CDRom and store
in my database.

Any suggestions.

Thankz
Mo

How is the address and zip information stored in the CD ROM? Is it
stored in an Excel sheet or are there separate files for the addresses?

SV

How is the address and zip information stored in the CD ROM? Is it
stored in an Excel sheet or are there separate files for the addresses?

SV

This type of data is usually comma delimited text with a header in a form
such as...

[street_address,city,state,zip]
16 Kincaid,Stinkyville,WI,53226-5433
2215 Cheese Head Ave.,Milwaukee,WI,53212-3878
....
....

It should be easy to search the web to find a tut to read and parse
delimited data.

<%= Clinton Gallagher
         METROmilwaukee (sm) "A Regional Information Service"
         NET csgallagher AT metromilwaukee.com
         URL http://metromilwaukee.com/
         URL http://clintongallagher.metromilwaukee.com/


Show quoteHide quote

1) Don't cross post this much :-
microsoft.public.dotnet.faqs,microsoft.public.dotnet.general,microsoft.public.dotnet.languages.vb,
microsoft.public.dotnet.languages.vb.controls,microsoft.public.dotnet.languages.vb.data,microsoft.public.vsnet.general
!!

Not nice.

2) Unless the design has changed these are zipped up CSV files with various
techniques used to minimize the data before storing and compressing. IIRC,
their website has info on how to access the data. I know I wrote my own
software to do it way back when.

alter built-in ContextMenu
Microsoft doesn't want you to use VB .Net
Unmanaged C dll call
The connection is dead
XML question
WIA.ImageFile to System.Drawing.Image
How to loop thru each controls ?
Oggetto Application di excel in vb net 2003
its a pain!
VBA to HttpWebRequest