Link to home
Start Free TrialLog in
Avatar of HOTWATT
HOTWATTFlag for United States of America

asked on

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
Avatar of Bill Prew
Bill Prew

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?

"ID" "t1" "n1" "t2" "n2"
1 "AAA" 111 "BBB" 222
2 "C" 3 "D" 4

Open in new window


»bp
Avatar of HOTWATT

ASKER

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
SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of HOTWATT

ASKER

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!