I am creating a Library Cataloging program for a local charity using Visual Basic.I have built the basic data table into the VB Project and I would like to populate it with the existing data that I have in the excel sheet containing the current catalogue. There are approximately 1000 records to import and I don't fancy inputing them by hand so I was wondering if anyone knows an easy way of porting the data across.
View 1 RepliesI am working on a project for a local charity to build a library catalogue of their books/music. I have built the main form and database but I would like to include the data they have already collated in excel (over 1000 records) so that it doenst have to be manually input into the finished program.is there an easy way to do this, I tried a cut and paste from excel into the data table in my project but unless I'm doing something wrong it wont let me paste the data into the table.
View 3 RepliesI'm trying to build an application to monitor a site to build statistics from the data being read. This HTML looks like this.
<div id="history">
<h4>HISTORY</h4>
<table border="0" cellspacing="0" cellpadding="0">
[code]...
Now I can read the html and put the text anywhere, I just don't how to read specific parts so I can separate the data out.
I've got an XML file which is a pain to manually update. So I was thinking of creating a small app which synchronizes this data for me based on data from an Excel Sheet or something.
The XML schema looks like this:
<Data>
<Level1 value="Canada">
</Level1>
<Level1 value="Chile">
[code]....
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..
View 3 RepliesI am trying to write a windows application in vb.net to import data from excel to sql server. I got "object not set to an instance of an object" error. The data actually have been inserted into the sql. The following is my code. I have a button when the button is clicked, it does frmProcess(). The first row is header in excel. I start to read data from 2nd row.
----------------------------------
Private Sub frmProcess()
Dim app As New Application()
Dim book As Workbook
[code]....
how can i import a Excel sheet Data into my oracle10g Database using vb.net coading..
View 1 RepliesI am new to VB.NET. How to import data from excel spread sheet into database (SQL Server Management Studio Express 2005) by clicking a button in windows form application using VB codes (visual studio 2010).
View 1 RepliesI have an access databse, but the data is link to excel, so i cant changes the data inside access database. However, i just want to retrieve the data inside the access database using VB datagridview, but the system pop out an error said 'cannot find the input table or query'Is it because the data is link with excel, so access databse cannot direct take the data? Below is my code:
Dim myconnectionstring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:mydatabase.mdb"
myconnection = New OleDbConnection(myconnectionstring)
[Code]....
I am trying to export an excel file directory into an Oracle table as opposed to looping through the range and executing a lot of insert statements. I would think that there are better ways to accomplish this in .NET but I can't seem to find any other answer besides convert excel to csv & load it using Sql Loader or External Table. Does anyone know a cleaner & more efficient way that looping through the ranges creating & executing insert statements?
View 3 RepliesI'm using a access database to store my data. I want to export the data in the access database to a excel 2007 file using VB.Net.
View 1 RepliesIs there a routine that will allow me to import data from an excel spreadsheet into a database within my project? I only need to do this to populate the the database I have created in my project.
While the project was being developed I used junk test data for testing and debugging but now I wan to populate the database with the actual records.
Here is the skinny:
In the project database I have the following fields:
ItemID - Primary key
SamCode
[Code].....
Column B contains the Full Name Data where B1 in a column header Column C contains the UPC Numbers needed where C1 is a column header
As stated this is a one time deal and not something I need to run as part of the application.
I have some trouble with opening a excel sheet and getting some data out of it.
I want my program to have a button, when pressed, gives a "select excel file" popup and then load the data from some cells into my sql database.
So, when opening a excel file the program should get the data from cell D3 to D8 and put that into the sql database.
I now have the following, but that will only open the excel file.
Public Class Form1
Dim oConn As ADODB.Connection
Private Sub ConnectDB()
[Code]....
I'm trying to write data from an excel spreadsheet to an Access database. When i run my program a message appears saying that the correct number of records have been saved, however when i check my access database no records have been written to the database table.
The following is a copy of my code (sorry i've just edited it to get rid of the white space that was added when i included it here for some reason.The code for writing to database:
Public Class Form1
Dim connection As OleDbConnection
Dim Command As OleDbCommand
[code]....
I want to read data from excel sheets and write into tables in database visual basic 2010. I am usinq Oracle 9i for database.and my objective is that user should select excel file and if button is pressed then I want to extract data from excel sheet and store in a already created tables.
View 5 Repliesi Have Used Database file for storing Data in my Application.Now I want to take backup of data in Access, Excel or in Any other Format.
View 1 Repliesim currently doing my special project in software development
[Code]...
i am trying to build an application where a specified number of cells are spoken from an excel file. what i want is something similar to what happens in excel, once u click play one cell after the other is selected and spoken and it automatically moves forward to the next, speaks and so on... but if i use voicecombo/SAPI.spvoice the UI freezes! any ideas?
[Code]...
how to build database
View 3 RepliesAm i correct when i say that at the end of the day a database can be built with a simple file stream and some logic to organize the data inside this big file??
View 6 RepliesI am really stugling with this an was hoping that someone has done this in the past and can lend some guidance, I have had a look on Google but I only seem to find examples of one parent and one child.Anyway back to the problem, I have a treeview on a form and I want to allow the user to create a tree structure of their choice. What I mean by that is no limit to parent and child combinations, so basically have the same functionality as in Window Explorer.Now comes the problem, what I want to be able to do is store this tree view hierarchy in a database, so that when they add a new node to the treeview it is stored in the database at the correct level. Then if the user closes the form and re-opens it loads the treeview hierarchy from the database.
View 1 RepliesI am really stugling with this an was hoping that someone has done this in the past and can lend some guidance, I have had a look on Google but I only seem to find examples of one parent and one child.
Anyway back to the problem, I have a treeview on a form and I want to allow the user to create a tree structure of their choice. What I mean by that is no limit to parent and child combinations, so basically have the same functionality as in Window Explorer. Now comes the problem, what I want to be able to do is store this tree view hierarchy in a database, so that when they add a new node to the treeview it is stored in the database at the correct level. Then if the user closes the form and re-opens it loads the treeview hierarchy from the database.I would really apreshiate some guidance on database table stucture and how I can loop through and build the treeview
Trying to build a front end for a new database I built at work, and I am having a problem.
This code is supposed to try to add a new customer to the database...in the
"btnSaveCustomerToDatabase_Click" VStudio is throwing "Reference to a non shared member
requires an object reference" but I am not seeing it.[code...]
I'm a Quite new to Visual Basic 2008. I have to build a database application for one of my assignments and one of the problems I'm having is to build a form that will be used to search a customer from a Customers table. The database is from access2007.
I have to have 4 radio buttons on the form which will be the options to search the customer by, so I can search by Customer ID, Customer Name, City and postcode. When I select one of those options I need to enter the phrase I'm looking for within a text box I have called TextBoxSearch then press a command button to perform that search but I'm not sure how to do this.
The customer ID is the 1st row, Customer name is the 3rd row, City is the 4th row and the postcode is the 5th row. How do i tell the program to go to that row and grab the detials based on the text entered from the text box? and display only those detials on the datagrid view?
I am trying to build up a login form for my database. I have two fileds Username and password and two buttons Login and change password. I want the change password button to get enabled only if the user enters a default password set by me and the button should remain disabled otherwise.
View 2 RepliesI am working on building a CMS, my client's specific request was that he should be able to modify/edit the nav menu and its contents using the user interface, I am not sure how to do it.
providing links to articles where I can learn? or even examples that I can implement?
Site2you.com has a template that can be edited pretty easily but I am not sure how they did it
I have a treeview on a form and I want to allow the user to create a tree structure of their choice. What I mean by that is no limit to parent and child combinations, so basically have the same functionality as in Window Explorer.
Now comes the problem, what I want to be able to do is store this tree view hierarchy in a database, so that when they add a new node to the treeview it is stored in the database at the correct level. Then if the user closes the form and re-opens it loads the treeview hierarchy from the database.
I would really apreshiate some guidance on database table stucture and how I can loop through and build the treeview
I have a past experience with visual Foxpro and SQL. Now, I need to build a database with multiple data files (say 100 files), each data file with millions of records, each record with dozens of fields.Then, each data file is linked with other files by using different fields. Primary data is in English. Then there would be a translation of the English data is in another language. Primary data in English is stored in separate files whereas the translated data is stored in separate data files.
View 4 Replieshow is the best way to build a database program using vb?
View 6 RepliesIm trying to construct a datarow from a dataset table rows collection and gets an error. [code]...
View 1 Replies