Miles function

[Guest]

Hello,

I have done some looking but with no luck in regards to using miles in
access. I have a table with all the zips in the US. I will have another
table with a finite number of zips. I want to run a query that will provide
me with all of the zip pairs between the two tables and then caculate the
miles between each zip pair.

I have PC Miler add-in in Excel that does this but I am going to be dealing
with a number of zip pairs greater than 65000. Any thoughts?

Thanks

 

[Guest]

Excel 2007 has a limit of 1,000,000 rows per worksheet. Will PC Miler work
with 2007?

 

[Guest]

Unfortunately my company is still using Excel 2003.

Michael

 

[John Spencer]

If you can't find the equivalent product for Access, you could try using
a query to break the results into chunks of 50K records and then process
this all in chunks in Excel.

Is that a viable solution for you.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Guest]

It will have to be.

thanks

Michael

If you can't find the equivalent product for Access, you could try using
a query to break the results into chunks of 50K records and then process
this all in chunks in Excel.

Is that a viable solution for you.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================