troubleshooting Question

issue exporting access table into txt file with correct format

Avatar of HOTWATT
HOTWATTFlag for United States of America asked on
DatabasesMicrosoft Access
5 Comments2 Solutions74 ViewsLast Modified:
Hey
I have an access table that I need to export to a txt file so I can use it to import into our database. I am exporting it with spaces and a text qualifier with quotes. In the preview screen it looks perfect. The text has quotes around it and the numbers do not but as soon as I export and open it everything has quotes around it including numbers which wont work when I try to import. I need just the text to have quotes. Any idea why it looks fine in the preview but then exports with everything in quotes? I added a couple attachments so you can see what I am talking about.
text_document.PNG
preview.PNG
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros