Sub importarExcel(ByVal tabla As DataGridView)
Dim myFileDialog As New OpenFileDialog()
Dim xSheet As String = ""
With myFileDialog
.Filter = "Excel Files |*.xlsx"
.Title = "Open File"
.ShowDialog()
End With
If myFileDialog.FileName.ToString <> "" Then
Dim ExcelFile As String = myFileDialog.FileName.ToString
Dim ds As New DataSet
Dim da As OleDbDataAdapter
Dim dt As DataTable
Dim conn As OleDbConnection
xSheet = InputBox("Digite el nombre de la Hoja que desea importar", "Complete")
conn = New OleDbConnection( _
"Provider=Microsoft.ACE.OLEDB.12.0;" & _
"data source=" & ExcelFile & "; " & _
"Extended Properties='Excel 12.0 Xml;HDR=Yes'")
Try
da = New OleDbDataAdapter("SELECT * FROM [" & xSheet & "$]", conn)
conn.Open()
da.Fill(ds, "MyData")
dt = ds.Tables("MyData")
tabla.DataSource = ds
tabla.DataMember = "MyData"
Catch ex As Exception
MsgBox("Inserte un nombre valido de la Hoja que desea importar", MsgBoxStyle.Information, "Informacion")
Finally
conn.Close()
End Try
End If
MsgBox("Tabla cargada exitosamente", MsgBoxStyle.Information, "Importado con exito")
End Sub
Suscribirse a:
Comentarios de la entrada (Atom)
Macro Exportar a txt
Sub proceso () 'por luismondelo ruta = ActiveWorkbook.Path & "\" Open ruta & "ejemplo.txt" For Output As ...
-
--Creamos una tabla temporal con un campo clave de tipo integer identity DECLARE @Tmp_Cliente TABLE( Id int identity(1,1) not null pri...
-
declare @columns nvarchar(MAX), @sql nvarchar(MAX) SET @columns = STUFF(( SELECT ',' + QUOTENAME(campo) FROM (SELECT DIST...
-
Sub proceso () 'por luismondelo ruta = ActiveWorkbook.Path & "\" Open ruta & "ejemplo.txt" For Output As ...
No hay comentarios.:
Publicar un comentario