Address Matching System

[Mario]

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

[Sankalp]

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

[Sankalp]

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

[clintonG]

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/
"Mario" <mo***@charter.net> wrote in message
news:dn**************@fe04.lga...

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

[Homer J Simpson]

"Mario" <mo***@charter.net> wrote in message
news:dn**************@fe04.lga...

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

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

1) Don't cross post this much :-
microsoft.public.dotnet.faqs,microsoft.public.dotn et.general,microsoft.public.dotnet.languages.vb,
microsoft.public.dotnet.languages.vb.controls,micr osoft.public.dotnet.languages.vb.data,microsoft.pu blic.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.