Search results for query: *

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...

Alternative method I have tried another method but am getting connection errors on the excel connection 'Excel Connection Dim plmExcelCon As System.Data.OleDb.OleDbConnection Dim PrmPathExcelFile As String PrmPathExcelFile = txtImportFileLocation.Text.ToString...

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...

I have added the table adaptor and dataset for the SQL table where the data is required to go. but i am unsure how to get data from the excel dataset/table to the sql dataset/table and do an update table adaptor comand. Any help is most appreciated. Dim plmExcelCon As...

Thanks i will give it go and let you know

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...