Transcript
Page 1: Cara Koneksi Vb.net Dengan Excel

KONSULTASIVB.COM - KURSUS VB.NET

Alamat : Terminal Bekasi - SPBU - Lampu Merah Taman - Gapura RT 02 RW 11

Jl. Rawa Semut - Semut Merah No 57 RT 04 RW 11 Belakang RS Bakti Medika

[email protected]

1

Imports System.Data.OleDb

Public Class Form2

Dim CONN As OleDbConnection

Dim CMD As OleDbCommand

Dim DS As New DataSet

Dim DA As OleDbDataAdapter

Dim RD As OleDbDataReader

Dim DT As DataTable

Dim LokasiData As String

Sub Koneksi()

LokasiData = "provider=Microsoft.ace.OLEDB.12.0;data

source=book1.xlsx;Extended Properties=Excel 8.0;"

CONN = New OleDbConnection(LokasiData)

CONN.Open()

End Sub

Private Sub Button1_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles Button1.Click

Call Koneksi()

DA = New OleDbDataAdapter("select * from [sheet1$]",

CONN)

DS = New DataSet

DA.Fill(DS)

DataGridView1.DataSource = DS.Tables(0)

DataGridView1.ReadOnly = True

End Sub

End Class

Top Related