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****@discuss ions.microsoft. com> wrote:

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

The following should work:

Function ExportAccessToT ext() As Boolean

Dim AccessConn As New System.Data.Ole Db.OleDbConnect ion("Provider=M icrosoft.Jet.OL EDB.4.0;"
& _
"Data Source=e:\My Documents\db1.m db")

AccessConn.Open ()

'New table
Dim AccessCommand As New System.Data.Ole Db.OleDbCommand ("SELECT * INTO
[Text;HDR=No;DAT ABASE=e:\My Documents\TextF iles].[td.txt] FROM Table_3", AccessConn)

AccessCommand.E xecuteNonQuery( )
AccessConn.Clos e()

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=F alse
Format=TabDelim ited
CharacterSet=AN SI
Paul
~~~~
Microsoft MVP (Visual Basic)