terima kasih ya atas bantuannya :) kan filenya ada diluar .xls yang saya inginkan adalah kita bisa mengambil data dari file tersebut sesuai dengan kolom dan baris nya yang telah kita tentukan sebelumnya di VB....
Igit Syah Riza <[EMAIL PROTECTED]> wrote: Kalau mau Import dari Excel bisa pake' cara ini, Dim cnExcel As New ADODB.Connection, rs As New ADODB.Recordset SQL = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = Letak_File\Nama_File.xls;Extended Properties = Excel 8.0" cnExcel.ConnectionString = SQL cnExcel.CursorLocation = adUseClient cnExcel.Open SQL = "SELECT * FROM [Nama_Sheet$]" rs.CursorLocation = adUseClient rs.Open SQL, cnExcel, adOpenKeyset, adLockBatchOptimistic Set GridEX1.ADORecordset = rs semoga bisa membantu.... ----- Original Message ----- From: eko santoso To: [email protected] Sent: Tuesday, February 06, 2007 9:10 PM Subject: [indoprog-vb] mengambil data dr excel (untuk kesekian kalinya) tolong... gmn caranya ngambil data dari file excel??? apa pertanyaan ini gak menarik ya... kok gak ada yang bantu.... makasih ya... --------------------------------- Need a quick answer? Get one in minutes from people who know. Ask your question on Yahoo! Answers. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] --------------------------------- It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar. [Non-text portions of this message have been removed]
