Improve company productivity with a Business Account.Sign Up

x
?
Solved

Keep Double Quotes When Exporting From Access To .TXT File

Posted on 2013-01-18
2
Medium Priority
?
635 Views
Last Modified: 2013-01-18
Hi Experts,

I'd like to keep the double quotes around the values when exporting to a tab-delimited file, however when i export the quotes are not there, do i need to do some sort of programming for that? All other values that do not have double quotes should not have them. I've made a visual presentation to explain better.

THanks so much.
Sample-Data.mdb
Problem-Visualized.docx
0
Comment
Question by:Dare626
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 1600 total points
ID: 38795414
how are you exporting the table?

for A2007
select the table
External Data > Export group,  select Text File

select the destination

in the Export wizard
select Delimited
select Tab
text qualifier None

here is the result
Tbl-MRR-Import-Data12.txt
0
 
LVL 31

Expert Comment

by:hnasr
ID: 38795430
What is the current output?
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

606 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