hi i'm having thesame problem with these:
cmd.CommandText = "UPDATE [tblJan_Abra] SET february=(SELEC T A.[february] FROM OPENROWSET('Mic rosoft.Jet.OLED B.4.0','Excel 5.0;Database=D: \sample_project \SPRS\Book1.xls ;HRD=YES','SELE CT * FROM [Sheet1$]') AS A) WHERE ID BETWEEN 388 AND 729"
pls help
harmony123
Last Activity: Apr 6 '11, 11:52 PM
Joined: Apr 23 '10
Location:
-
i have a database table named tblAbra which has columns: id,project,janu ary,february,ma rch,april,may-december..now im going to populate these table by importing the data from excel..since the population of the data are on monthly basis..those columns who don't hve data yet are set to null..example if im going to add the 1st data im going to import it from excel importing only the data from january column..now if the data of february is already available...Leave a comment:
-
import data from excel to sql database
hi have anyone tried importing specific column of an excel sheet to an sql database?
i have tried importing data from excel and it worked but my problem is i want to import only specific columns from my excel file not necesarily importing all the columns.. -
I also have thesame declaration but when i've added a reference COM module of excel 5.0 i've got this error..New cannot be used as an interface..pls helpLeave a comment:
-
Export data to Excel
I would like to export data from textboxes to excel. i've added a reference excel 5.0 to my project and i have the following code.
...Code:Dim excelApp As New Excel._ExcelApplication Dim excelBook As Excel.Workbook = excelApp.Workbooks.Add(System.Reflection.Missing.Value) Dim excelWorksheet As Excel.Worksheet = _ CType(excelBook.Worksheets(1), Excel.Worksheet) excelApp.Visible = TrueLast edited by Frinavale; May 4 '10, 03:16 PM. Reason: Please post code in [code] ... [/code] tags. Added code tags. -
by the way here is my sql query..
Code:cmd.Connection = conn conn.Open() cmd.CommandText = "SELECT tblJan.january+tblJan_Abra.january FROM tblJan,tblJan_Abra"Last edited by Frinavale; May 4 '10, 03:24 PM. Reason: Please post code in [code] ... [/code] tags. Added code tags.Leave a comment:
-
hi!..tnx 4 ur reply..these is what i've come up too based on what i've read..but with these codes i cnt display ol d rows in my database..examp le if i have 3 current data on my database then i should display those on 3 textboxes also..
...Code:If dt.Rows.Count < 1 Then MsgBox("Record not Found", MsgBoxStyle.OkOnly + MsgBoxStyle.Information, "Search") End If Me.BindingContext(dt).PositionLast edited by Frinavale; May 4 '10, 03:24 PM. Reason: Please post code in [code] ... [/code] tags. Added code tags.Leave a comment:
-
how to display multiple records in multiple textboxes
I would like to display the multiple records in multiple textboxes
Following is my tables and data:
tblJan with these data:
col id
1
2
3
col January
10
20
30
now i want to display the value 10 in one textbox and the value 20 in another textbox and so with the value 30 in another textbox..
i am new in vb.net and a help would be greatly appreciated..tn x..
No activity results to display
Leave a comment: