Microsoft Access
--
Questions
--
Followers
Top Experts
issue exporting access table into txt file with correct format
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
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
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
I just tried a simple test in Access 2016 here and it worked as you wanted it to. Below is the output simple sample text file, with two text columns, and two number columns. What version are you using?
How are the number fields defined in the table, and what formatting etc do they have?
»bp
How are the number fields defined in the table, and what formatting etc do they have?
"ID" "t1" "n1" "t2" "n2"
1 "AAA" 111 "BBB" 222
2 "C" 3 "D" 4»bp
I am using access 216
I have one field that is short text and all the rest are number. The number columns are formatted as decimals. I added an attachment of the format for the number columns.
format.PNG
I have one field that is short text and all the rest are number. The number columns are formatted as decimals. I added an attachment of the format for the number columns.
format.PNG
SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
That was the issue. The decimal format was being treated as text for some reason. I switched that and everything exported correctly. Thanks for all the help!
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Microsoft Access
--
Questions
--
Followers
Top Experts
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.