There is a limit to the size of numeric fields. I don't remember offhand what it is but I would think numbers in the trillions would be accommodated. Search Access help for specifications and limits for your version.
This will convert the number to a string. Use the function a query and export the query rather than the table.
Format(yournumber,"###,###,###,###.##")