Q. How do I download large files from TranStats?

Answer

  • TranStats downloads of airline Origin and Destination Survey and On-Time data may be larger than the number of rows allowed by older versions of Microsoft Excel
  • Microsoft Access can be used to open ​and aggregate data
    • Note: If you are trying to calculate RPM's, ASM's, etc., you can't aggregate or you will get a total that's too large
  • Access videos and tutorials provided by Microsoft 

(Note: The above private-sector site is not maintained by USDOT or any other US Government office. We take no responsibility for the content or accuracy of any non-USDOT web page, and offer the above link strictly as a courtesy, should you be interested.)

  • Last Updated May 31, 2018
  • Views 22
  • Answered By David Martin

FAQ Actions

Was this helpful? 0   0

Contact Us

These FAQs only cover topics related to the Bureau of Transportation Statistics (BTS). Please see the DOT homepage for access to all DOT Administrations. 

Can't find the answer you're looking for in the FAQs? Contact us for help.