Input Mask - Export into Excel

[gbobbie]

I have a query in MS Access that pulls fax numbers and I have Excel set up to receive that information via MS Query. However, although the table and query in Access where the fax numbers are stored have input masks for the fax numbers that include ;0 to store the data like that, it pulls it across in Excel as unformatted numbers. Is there anyway to pull across the input mask formatting? Thank you!

 

[PHV]

Why not using the Format function in your query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Remou]

I tried this in Access 2000. I created a text field and an Input Mask:
####\-####;0
I then built a query and connect to the query through Microsoft Query in Excel. The numbers can across formatted.