Format when exporting data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When exporting data from Reports to Excel , the
data is not properly formatted.
 
Vineet

Create a query that returns the data. In the query, use the Format property
and function, and the "conversion" functions (CDate(), CInt(), etc.) to
coerce the data to be in the format you wish exported.

Then export the query.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best third-party tool to repair OST files 3
Exporting to Excel 2007 1
Problems exporting large query results to text delimited format 2
Keeping format when exporting to excel 1
Export Access Report to Excel keep format 4
Change default destination for exporting data 1
Export or Import to Excel and Format 4
Access to excel, export? 1

Back
Top