>>Hi Edmond,
>>
>>We deal with the similar problem here. We use Mailer's files which we receive monthly. Using Mailer software we prepare an extract into txt file, then I do some manipulations and create a VFP Streets table, which we lately use for Address Standardization and Zipping. We use data for NE states only (as I recall, we filtered 4 states: MA, CT, RI, NH) and it's about 5-6mln. records.
>>We decided to not do Owner Address standardization for non-NE owners, since the percent of non-NE owners is relatively small. Anyway, you can divide data by regions, or by State, name them correspondingly, say, MEStreets, AZStreets, etc.
>
>Nadya,
>
>I assume that you use Mailer's own export function to export the data to a txt file or do you know what data format that Mailer's+ keeps the national database in and do the exporting yourself?
>
>Ed
>
>Ed
No, I don't know the inner details of Mailer program, though I may try to figure this out. Yes, we use its own export function. I can tell, that this program is very memory consuming, e.g. when we run Mailer program, we can not run other applications on this machine.
If it's not broken, fix it until it is.
My Blog