Who can help me?
-
HI ALL, I WOULD LIKEE TO EXPORT THE ACCESS DATABASE TABLE DATA IN EXCEL FROM VB6.0.I USED ADO REFERENCE TO CONNECT THE DATABASE.HOPE FOR QUICK SOLUTION. PAWAN -- modified at 5:12 Wednesday 22nd August, 2007
Hi, I am using oracle to connect to the db and I have written the below code in vb.net. Any way u can try it and feedback me. imports Microsoft.Office.Interop Dim xl As New Excel.Application xl.Workbooks.Add() xl.ActiveSheet.Name = "Cash Report" xl.Visible = True j = 1 l = k = 0 For i = 1 To n - 1 j = 1 l = 0 For l = 0 To 4 xl.Cells(i, j) = ds.Tables(0).Rows(k)(l) j = j + 1 Next k = k + 1 Next
Ahamed Azeem Software Programmer Saudi Postal Technologies – Riyadh
-
Hi, I am using oracle to connect to the db and I have written the below code in vb.net. Any way u can try it and feedback me. imports Microsoft.Office.Interop Dim xl As New Excel.Application xl.Workbooks.Add() xl.ActiveSheet.Name = "Cash Report" xl.Visible = True j = 1 l = k = 0 For i = 1 To n - 1 j = 1 l = 0 For l = 0 To 4 xl.Cells(i, j) = ds.Tables(0).Rows(k)(l) j = j + 1 Next k = k + 1 Next
Ahamed Azeem Software Programmer Saudi Postal Technologies – Riyadh
in vb 6.0 we can use the referance of the excel library.i used the excel library and export the data but my problm is that i have to already create excel file in certain location and display the record in that file .but i want to export the data with out creating excel file already.(have u undestood or not if not noty fy me)
-
in vb 6.0 we can use the referance of the excel library.i used the excel library and export the data but my problm is that i have to already create excel file in certain location and display the record in that file .but i want to export the data with out creating excel file already.(have u undestood or not if not noty fy me)
Do u need to update the data into the same excel which was created earlier? -- modified at 6:12 Wednesday 22nd August, 2007
Ahamed Azeem Software Programmer Saudi Postal Technologies – Riyadh
-
Do u need to update the data into the same excel which was created earlier? -- modified at 6:12 Wednesday 22nd August, 2007
Ahamed Azeem Software Programmer Saudi Postal Technologies – Riyadh
-
Hi, The following code snippet will create a new excel file. Dim xl As New Excel.Application xl.Workbooks.Add() xl.Visible = True
Ahamed Azeem Software Programmer Saudi Postal Technologies – Riyadh
-
Hi, The following code snippet will create a new excel file. Dim xl As New Excel.Application xl.Workbooks.Add() xl.Visible = True
Ahamed Azeem Software Programmer Saudi Postal Technologies – Riyadh
-
hi sorry that code is not worked.simply i want to expor the data in excel by using vb 6.0 .my data base is MS Access.
Hi, Please import the reference of microsoft excel(its a com file) into your application and then try. Because its working fine with my application.
Ahamed Azeem Software Programmer Saudi Postal Technologies – Riyadh
-
HI ALL, I WOULD LIKEE TO EXPORT THE ACCESS DATABASE TABLE DATA IN EXCEL FROM VB6.0.I USED ADO REFERENCE TO CONNECT THE DATABASE.HOPE FOR QUICK SOLUTION. PAWAN -- modified at 5:12 Wednesday 22nd August, 2007
Your CAPS-LOCK key seems to be most probably on. Typing in ALL-CAPS normally indicates a bad temper (viz) shouting. It may also indicates an amateurish attitude in a public discussion forum.
Vasudevan Deepak Kumar Personal Homepage Tech Gossips
-
hi sorry that code is not worked.simply i want to expor the data in excel by using vb 6.0 .my data base is MS Access.
Did you try using the DTS Wizard option that comes with SQLServer. There is an option to transfer between heterogenous data sources in it.
Vasudevan Deepak Kumar Personal Homepage Tech Gossips