Solved

Export Access Query to Excel Maintain Leading 0

Posted on 2009-07-01
2
246 Views
Last Modified: 2013-11-27
I have an Access database Query  that I am exporting to Excel.
There is a field that is a zip code that is 00990 - when I export it shows in Excel as 990
I need it to be 00990
0
Comment
Question by:Pdeters
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 24757842
how do you export the query?

in the query emphasize that the field is text  with  cstr([Zip code])
0
 

Author Comment

by:Pdeters
ID: 24758176
DoCmd.TransferText acExportDelim, , "Query", strLocation & "File.CSV"
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Email Header Detail 12 55
SQL Group on First occurrence 9 26
Loops and updating in SQL Query 9 31
My SQL as Backend for Access 3 18
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question