Search results for query: *

  • Users: droyce
  • Content: Threads
  • Order by date
  1. D

    Question Unable to cast object of type 'System.Data.DataTable' to type 'Microsoft.Office.Inter

    I keep getting the following error every time i run this script i cannot find any info why this is happening and how to fix it, any help would be great Dim plmExcelCon As New System.Data.OleDb.OleDbConnection Dim cmdLoadExcel As System.Data.OleDb.OleDbDataAdapter Dim...
    • droyce
    • Thread
    • ado.net excel.net component visual basic
    • Replies: 1
    • Forum: ADO.NET
  2. D

    Importing Excel to a SQL DB table visual basic

    I am trying to write data from an excel spread sheet to a SQL Database. I have been able to connect to the Excel Spreadsheet and read the data but I am unable to get the data to insert into the SQL DB table. the current code is as follows any help most appreciated. Dim plmExcelCon As...
  3. D

    Question Importing Excel to already established SQL DB visual basic

    I have a program which needs excel data imported into a SQL DB table. I have done a lot of research into how to do it but have not found anything that is usefull. the SQL DB table is already set with data in it and the new data is supplied in an excel format and so i need to import it making...
Back
Top