Using SQL to export Access Database to file

Hi guys,

I have been trying to export a database to file with no delimiters currently. Eventually, I need to put in the delimiters, but I'd like to do this step by step. I want to run this sql statement on my export.

SELECT [Transactions].[transaction id], [Transactions].[sequence number], [Transactions].[transaction code], [Transactions].[current location], [Transactions].[patients last name], [Transactions].[patients FIRST name], [Transactions].[patient id number], [Transactions].[admit / discharge date], [Transactions].[admit / discharge time], [Transactions].[patient age], [Transactions].[patient sex], [Transactions].[patients old roombed]
FROM Transactions
WHERE ((([Transactions].[Include])=Yes));

Sorry, that it's somewhat messy. I just copied it out of my old Access app that I used it for. Anyways, I want to run that and then take those records to file. I already have the form set up for the user to edit all records, but now I have to get into this. Thanks for the help guys!

Are you wanting to pull data from access and place in a text file? Is this initiated from an application or on schedule?

I want to do this on demand. I want to have an export button that you click to take the database to text file with the specs i talked about earlier. Thanks for helping out.

Jason

One possible solution create a macro to execute a predefined query and export data.
...
You could also create a module that will open a text file and the data to this text.

i have the data now going to file, but it is going by default with commas and quotes

"data", "data1", "data2",

Like that. How can i get rid of these quotes and commas

How are you exporting the data? Are you using MS Access? If so, check to see if you can adjust/edit the delimiters.

Can I ask, how could you do the data export with SQL sentence? Can you, please, write me that line?

Thank you.