Export Access to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
How to export Access table to Excel sheet programatically
Thanks.
 
¤ Hi,
¤ How to export Access table to Excel sheet programatically?
¤ Thanks.

See if the following helps:

Public Sub ExportToExcelFromAccess()

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

AccessConn.Open()

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 ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Export Gmail Emails to PST Format? 4
Exporting to excel 1
Exporting Data From Excel to SQL 1
Word to Excel: Export comments with text and line number 0
Export to excel format file 9
How to Convert EML to PST? 2
Best Gmail Backup Tool to use in 2025? 3
Export Rows as CSV / Covert Rows to Columns 2

Back
Top