Use SELECT INTO in C# to export Access table to csv file

[MichaelHooker]

At this topic "https://bytes.com/topic/visual-basic-net/answers/530817-convert-access-table-text-file-using-vb" is the following Q&A:
=============== =============== ========
"I have a MS access table and I want to export it to comma delimited
¤ text file. How do I do this programmaticall y using VB.NET or C#?
¤
¤ Thanks for any help in advance.

You can do this rather easily with ADO.NET and SQL:

Dim AccessConn As New System.Data.OleDb.OleDbConnection("Provider=Micros oft.Jet.OLEDB.4.0;"
 & _
 "Data Source=e:\My Documents\db1.mdb")
 
 AccessConn.Open()
 
 Dim AccessCommand As New System.Data.OleDb.OleDbCommand("SELECT * INTO
 [Text;HDR=No;DATABASE=e:\My Documents\TextFiles].[td.txt] FROM Table_3", AccessConn)
 
 AccessCommand.ExecuteNonQuery()
 AccessConn.Close()

Paul

~~~~
Microsoft MVP (Visual Basic)
=============== =============== =============== ====

Now I am trying to do the same in C#, but I cannot work out what the line

"("SELECT * INTO
 [Text;HDR=No;DATABASE=e:\My Documents\TextFiles].[td.txt] FROM Table_3", AccessConn)" 

is supposed to do in order to make it work in my application. I'm guessing as follows:
Text = output format ?
HDR=NO means no header line ?
DATABASE = the path to the output file ?
.[td.txt] = the name of output file ?
Table_3 = the name of the Access table in the mdb file ?

Is there anything I need to change in its formatting to make it work in C#? The code I am trying is this:

OleDbConnection AccessConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\PlaneBase\\pb_mil.mdb");
AccessConn.Open();
OleDbCommand AccessCommand = new OleDbCommand("SELECT * INTO [Text; HDR = No; DATABASE = c:\\PlaneBase\\].[MilTable.txt] FROM military", AccessConn);
AccessCommand.ExecuteNonQuery();
AccessConn.Close();
 

and the error I am getting is this:
"An unhandled exception of type 'System.Data.Ol eDb.OleDbExcept ion' occurred in System.Data.dll

Additional information: Could not find file 'c:\users\micha el\documents\vi sual studio 2015\Projects\A ccessTest1\Acce ssTest1\bin\Deb ug\Text'."
Why is it even looking for a file called "Text" ?
Many thanks.

Michael

[MichaelHooker]

I would love to have used this SELECT INTO construction, but in the absence of any useful information that I could find on the net, and with no response here, I tried a less elegant program solution - retrieving lines of data and saving them one at a time to a text file. It takes ages but it works.

Does anyone know where I can find further info on this use of SELECT INTO to create a text file, as promoted by Microsoft MVP Paul, who is (or was?) a member of this community ?

Thanks

Michael