Access table to tab delimited text file?

[Job Lot]

Using VB.NET how can I convert access table to tab delimited text file?

Thanks

[Paul Clement]

On Tue, 29 Mar 2005 23:25:03 -0800, "Job Lot" <Jo****@discussions.microsoft.com> wrote:

¤ Using VB.NET how can I convert access table to tab delimited text file?

The following should work:

Function ExportAccessToText() As Boolean

Dim AccessConn As New System.Data.OleDb.OleDbConnection("Provider=Micros oft.Jet.OLEDB.4.0;"
& _
"Data Source=e:\My Documents\db1.mdb")

AccessConn.Open()

'New table
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()

End Function

You will need a schema.ini file if a custom delimiter (tab) is required. The contents will look like
the following:

[td.txt]
ColNameHeader=False
Format=TabDelimited
CharacterSet=ANSI
Paul
~~~~
Microsoft MVP (Visual Basic)