Export Access file to Excel in VB.net.

[sam]

Can you teach me how to export access file to excel file
in VB.net?

Thank in advance.

[Ken Powers]

Do you want to export an Access table to Excel?

[Herfried K. Wagner [MVP]]

Hello,

"sam" <s9******@cc.ncu.edu.tw> schrieb:

Can you teach me how to export access file to excel file
in VB.net?

You may want to ask in the Access ngs (microsoft.public.access[.*]). Then
you can translate the solution to VB .NET.

HTH,
Herfried K. Wagner
--
MVP · VB Classic, VB .NET
http://www.mvps.org/dotnet

[Paul Clement]

On Tue, 26 Aug 2003 07:19:52 -0700, "sam" <s9******@cc.ncu.edu.tw> wrote:

¤
¤ Can you teach me how to export access file to excel file
¤ in VB.net?

You can do it a table at a time:

Public Sub ExportToExcelFromAccess()

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 sheet in Workbook
Dim AccessCommand As New System.Data.OleDb.OleDbCommand("SELECT * INTO [Excel
8.0;DATABASE=e:\My Documents\Book11.xls;HDR=NO;].[Sheet7] from [Table7]", AccessConn)

AccessCommand.ExecuteNonQuery()
AccessConn.Close()

End Sub
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)