How do I export the result of SQL query(MS ACCESS) as a text file (.txt)

Question

1.00/5 (2 votes)

See more:

Does anyone help me ? I just start a new job for 5 days. I was assiged to export the result of SQL query(MS ACCESS) as a text file (.txt) that consist of header (filed name) and line items (list of results) and specify the space between each of them. I know that MS ACCESS can export text file but he does want that format. In this case, I dont really know what to do. I dont want to be fired. please help me.

What I have tried:

export by using export ribbon.

Posted 1-Jul-18 4:51am

Member 13894111

Updated 1-Jul-18 6:19am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2018-07-01T06:19:00

This is very easy to do with a bit of work. If you can't do this yourself, you're not going to be in this job for very long.

This is just 3 simple steps. Build and execute the query to return a result set.

Iterate over the records returned (for loop of some kind) and get the next record from the returned result set.

Get the value from each field from the record and format it and write the fields to the file in the format required.

Having said that, if you think "helping you" means someone is going to write the code for you, you're already fired.