Hi, I have copied the data in a new dataset "ds1". Please tell me how to copy this "ds1" contents into Access Database. I am trying with following: Dim da2 As New OleDbDataAdapter Dim conn As OleDbConnection Dim cmd As OleDbCommand = New OleDbCommand() conn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\alldata.mdb;") cmd = New OleDbCommand("SELECT * FROM Denver", con) da2 = New OleDbDataAdapter(cmd) da1.Fill(ds1, "Denver") But not able to populate the Access database. Can You guide me how to do this?? Thanks, R.S.

Sorry By mistake.... I made the statement "But not able to populate the excel sheet." What i was: "But Not able to populate the Access Database". Thanks R.S.

Hi, I have copied the data in a new dataset "ds1". Please tell me how to copy this "ds1" contents into Access Database. I am trying with following: Dim da2 As New OleDbDataAdapter Dim conn As OleDbConnection Dim cmd As OleDbCommand = New OleDbCommand() conn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\alldata.mdb;") cmd = New OleDbCommand("SELECT * FROM Denver", con) da2 = New OleDbDataAdapter(cmd) da1.Fill(ds1, "Denver") But not able to populate the excel sheet. Can You guide me how to do this?? Thanks, R.S.

I am trying this: Dim ds1 As New DataSet Dim da As OleDbDataAdapter = New OleDbDataAdapter("SELECT * FROM [Sheet1$]", connection) da.Fill(ds1) But getting same error: The Microsoft Jet database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly.

I have gone through this, and I tried to implement somehow. The implementation is as follows: // first connected xl datasheet: Dim filename As String = "C:\Student.xls" Dim con As String con = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & filename & ";" & "Extended Properties=Excel 8.0;" Dim connection As OleDbConnection = New OleDbConnection(con) connection.Open() // now copying the excel column into access database table columns: Dim cmd As New OleDbCommand cmd.Connection = connection Try cmd.CommandText = "SELECT * INTO [MS Access;Database=C:\alldata.mdb].[Record] FROM [Sheet1$]" cmd.ExecuteNonQuery() connection.Close() MsgBox("The Import is Compelte") Catch ex As Exception MsgBox("Import Failed, correct Column name in the sheet!") End Try While executing I am getting following error: The Microsoft Jet database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly. I am using Microsoft office 2007 with Access 2007 database. Please tell me how to solve this? Regards, R.S.

Hi All, I have one Excel sheet "Student.xls", which has different worksheet as "Sheet1","Sheet2"..like that. Consider now "Sheet1"; it has 3 columns - "Name", "Age", "Sex". All these columns has row entries. Now I have one access database, "alldata.mdb". It has One table "Record" which has 3 fields as same as column name of Excel sheet-- "Name", "Age", "Sex". I want to populate this access database with the entries of Excel sheet from "Sheet1". Can someone let me know how to do this? I tried this: // first connected xl datasheet: Dim filename As String = "C:\Student.xls" Dim con As String con = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & filename & ";" & "Extended Properties=Excel 8.0;" Dim connection As OleDbConnection = New OleDbConnection(con) connection.Open() The above Excel connection was succesful, but how to import the data from this excel sheet into the access database. Please suggest. Thanks, R.S.

Hi All, I have one Excel sheet "Student.xls", which has different worksheet as "Sheet1","Sheet2"..like that. Consider now "Sheet1"; it has 3 columns - "Name", "Age", "Sex". All these columns has row entries. Now I have one access database, "alldata.mdb". It has One table "Record" which has 3 fields as same as column name of Excel sheet-- "Name", "Age", "Sex". I want to populate this access database with the entries of Excel sheet from "Sheet1". Can someone let me know how to do this? I tried this: // first connected xl datasheet: Dim filename As String = "C:\Student.xls" Dim con As String con = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & filename & ";" & "Extended Properties=Excel 8.0;" Dim connection As OleDbConnection = New OleDbConnection(con) connection.Open() The above Excel connection was succesful, but how to import the data from this excel sheet into the access database. Please suggest. Thanks, R.S.

Hi All, I have a SQL database column, name "Closing Date" with datatype as Datetime. For example, the entries are like this: 1-Nov-2009 21-Dec-2009 10-Jan-2010 21-Mar-2010 11-Apr-2010 Now What I want is to select a date which is less than my requested date from a text box. e.g. If I want to select a date which is less that 31-Mar-2010, then I should get 21-Mar-2010. or, If I want to select a date which is less that 9-Jan-2010, then I should get 21-Dec-2009. Presently I am using following in VB.net. cmd = New SqlCommand("SELECT [Closing Date] FROM client_details WHERE [Closing Date] <= textbox.text", con) But I think I need to use something else. Hope My query is clear. Please suggest me how to go ahead? Regards R.S.

Hi All, I have 600 rows entries in a SQL database column "Name". At present I am looping through each row and searching for a text which should match the entries in "Name" column. My code is like this: For Each dr As DataRow In myDataSet.Tables(0).Rows If Trim(dr(("Name"))) = Trim(search_text) Then ' matching found... End If Next above, myDataSet contains the "Name" column data. Now, the above code is very time consuming, because it has to loop entire 600 times... What I am looking is any simple method, by which it direct jumps into the matched row and read the entries. Can someone suggest me how to do this? Regards, R.S

Thanks....Any sample example/link will be appriciated.

Hi Everyone, I am using MS Access database with VB.NET. My problem is very simple. It is as follows: I have two tables "Class" ( with a field "Class") & "Section"( with a field "Section"). I can fill both this tables of MS Access database programmaticaly thorough VB.NET. There are two textboxes t1 & t2 on the Form to fill corresponding fields "Class" & "Section" of the tables. Now what I want is to fill "Class" field and then "Section" field in such a way that for each entry of "Class" field, there will be entry in "Section" field. e.g. Insert class 1 in textbox t1 Insert setion A in textbox t2 While save, section A must be saved under class 1. Similarly, if I Insert class 1 in textbox t1 Insert section B in textbox t2 then, section B should come under class 1. Similarly, if I insert class 2 and then section A & section B, then both this sections should get stored under class 2. Overall, there should not be any conflict between class and section entries. i.e. each class entries has its corresponding section entries. Hope My issue is clearly. Can someone help me how to do this? Any example would be appreciated. Regards R.S.

Hi All, Last month I posted this question, but I think I didnt get response for that. Anyways, I would like to ask again: I am one vb.net windows application installed on my client's PC. Now my client has asked some changes in the code and re-send that application, so that he can uninstall the previous version and install the updated version. From my end, I have done the requested modification and created a Setup & Deployment project in VS2005. Now I dont want him to uninstall the previous version of that application installed on his PC. I want to update his installed application with the updated one ( which I made on my PC) without un-installing his last version. Can someone Pls let me know how to create this? Any patch building is required or not? I am new to this, though i can send him the updated exe so that he can uninstall the previous version and install the new version, but i dont want him to do...I want him to directly update his present verion of the application already installed. Anyhelp would be appreciated. Regard, R.S.

Hi All, I created a website using Visual Studio 2005 ASP.NET. Can I run this on a 3rd party server? I purchased a 3rd party web hosting plan ( www.znetindia.com) which supports ASP.NET/SQL/MS Access features. Can someone tell me how to do this, any links,reference would be useful. Regards R.S

I have created a setup & deployment project and installed the exe on my client's machine. So there is no way to update that file on my client's machine. One way is to recreate the whole SEtup & deployement project with the updated file and re-install on my client's PC, but I dont want to un-install the current version; I just want by anyhow if I can update the application.

Hi All, I have created an application in Visual Studio 2005 .NET, which I installed on my client's machine. This application/project has one file, 'Form2.vb', which needs some updation. Now I want to update the installed application with this new/updated file without uninstalling the current version installed on my client's machine. Can someone Please let me know how to do this. I dont want web updation, I can go to my client's machine and update the installed application. Hope I am clear. Regards, R.S.

Hi All, I am looking for source codes/ .dll files which I can use in my project to create stylish buttons/Forms/Controls. Can someone suggest something on this? Regards R.S.

Dear All, I have a Form in VB .net 2005, on which a calender control is added to select date. I have added a crystal report also in my project. Now I want to add the date dynamically on the crystal report, i.e. if i select a date in calender control placed on the Form, the corresponding date should come/display on the crystal report ( whenever it is generated). Hope I am clear. Please note that I want to do this without creating any database to store the dates from the calender control. Please suggest me how to do this asap. Regards R.S.

Hi All, I created a setup package for my project in Visual Studio 2005. I installed on a separate PC and the exe can be run from desktop also. The executable is showing on my desktop but it is not displaying any image/logo/icon etc. I mean, its showing a square shape exe on the desktop. What I want is, whenever the exe is created on the desktop during installation, I want it to be created as an image or logo or icon. It should be same as we install Visual studio software and a desktop icon is created with title "Visual Studio 2005". I think I am able to make my requirement clear. Is there any setting for this during creation of setup file in VS 2005? Regards, R.S.

Dear All, I have a SQL database with 3 columns A, B, C. Under these 3 columns, there are 100 entries. I want each row to be printed on each page of crystal report, so that i get a separate page for each row entries of the database. Can someone suggest me how to implement this? Regards R.S.

Hi, I didnot get Your idea. I am just looking for a tutorial to build such kind of application.