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

DatabasesMicrosoft Access

Last Comment

HOTWATT

8/22/2022 - Mon

Bill Prew

11/7/2017

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

HOTWATT

11/7/2017

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

Bill Prew

11/7/2017

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

ASKER CERTIFIED SOLUTION

PatHartman

11/7/2017

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

⚡ FREE TRIAL OFFER

Try out a week of full access for free.

Find out why thousands trust the EE community with their toughest problems.

HOTWATT

11/7/2017

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!

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst

William Peck