Solved

Keep Double Quotes When Exporting From Access To .TXT File

Posted on 2013-01-18
2
534 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 119

Accepted Solution

by:
Rey Obrero earned 400 total points
Comment Utility
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 30

Expert Comment

by:hnasr
Comment Utility
What is the current output?
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

728 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now