Search VB 2010

Sunday, December 15, 2013

Visual Basic Compare Two Treeviews and return differences

Visual Basic 2010 - Compare Two Strings and return differences and matches

vb2010 compare strings and return differences
VB2010 Compare Strings in Collections

Collections as an Alternative to Arrays

Visual Studio 2010
Although collections are most often used for working with the Object Data Type, you can use a collection to work with any data type. In some circumstances, it can be more efficient to store items in a collection than in an array.



If you need to change the size of an array, you must use the ReDim Statement (Visual Basic). When you do this, Visual Basic creates a new array and releases the previous array for disposal. This takes execution time. Therefore, if the number of items you are working with changes frequently, or you cannot predict the maximum number of items you need, you might obtain better performance using a collection.

A collection, which does not have to create a new object or copy existing elements, can handle resizing in less execution time than an array, which has to use ReDim. But if the size does not change, or changes only rarely, an array is likely to be more efficient. As always, performance is highly dependent on the individual application. It is often worth your time to try both an array and a collection.

This Example

How to compare two Treeviews in VB2010
How to return the differences between two Treeviews

Solution

- Create Visual Basic 2010 Windows Application Project
- On Form1, place two tree views and two textboxes and one button

Visual Basic Online Course
Visual Basic 2010 Compare Strings from Treeview
How does it work ?
- Store the Treeview1 [TRV1] nodes into Textbox, and the same with Treeview2 [TRV2]
- How many strings [Lines] in each Textbox

  • We want to find where both Textboxes is different and where both Textboxes is match to one another. For example, differences are :
- TRV1 has an extra string [Southern American]
- TRV2 node string [Africa] is different from TRV2 node string [African]

Steps to accomplish this task :





Download example from Mediafire
Extended work :
You can easily extract any Database tables, columns Schema into a treeview control, and you can also using this example compare two tables or two columns in a Database using this example as well.

You can use ListViews or ComboBoxes or ListBoxes instead of the Treeview control, I used the treeview control because it's always tricky to work with. Using other controls that store strings in Collection format would be so easy, even much easier than using Treeviews.

Another Treeview Examples

Expand and Collapse two treeviews at the same time according to one another even if they both don't have the same nodes names. Expand TreeView1[TRV1] node when TreeView2 [TRV2] node is expanded or collapsed.

TreeView Example : Change the node font

TreeView Example : Add a photo (icon) to the TreeView
1) Add ImageList from the ToolBox
2) Add 2 photos to the ImageList1 [From properties, Collection], for example :
- Photo1.Png (Index by default is Zero 0), this will be the Parent icon
- Photo2.Png (Index by default is One 1), this will be the first child icon
3) Code to display image/Icon in the Tree View :


Here are some online Visual Basic lessons and courses :

Saturday, November 02, 2013

VB 2010 Advantage Database Example

Sybase Advantage Database With Visual Basic 2010

Update Sybase Advantage Database using XML file from Visual Basic 2010 [Client-Server] Idea.
Update Sybase Advantage Database using XML file from Visual Basic 2010 [Client-Server] Idea.
1. Create New VB2010 Windows Application Project
2. Path to Project (I.e. D:\MySyBase\)
3. Path to Database (I.e. D:\MySyBase\Bin\Debug)
4. Sybase Advantage Database (MyDB.add)
5. Sybase Advantage Database Username : AdsSys - Password : ahmed
6. Sybase Advantage Database Table (I.e. MyInfo.adt)
We will create a personal Info application, so the table structure will be like that :
Sybase Advantage Database
Visual Basic 2010 - Sybase Advantage Database
Note : All other fields will vary in [Size] only but all fields are [cicharacter] Data Type.

Visual Basic Form Deign :
Visual Basic 2010
Visual Basic Online Courses
Note : I have made TextBoxes with Naming convenient (I.e NameTxt, EmailTxt, MobileTxt .... etc). Also I've placed 1 DataGridView and some Buttons. I also have 1 Module [Module1].

SaveBtn : Save new record to the Advantage Database
SearchBtn : Search for records using by Sname
EditBtn : After search, edits the record
DeleteBtn : After search, deletes the record
CancelBtn : Reset the form and the DataGridView
ExitBtn : Exits the application

In order to use Sybase Advantage Database with Visual Basic 2010 and just like any other Database, you must call the References to the Database :
Visual Basic 2010 - Add Reference to Sybase Advantage Database

The Codes
Module1

Form1
Sub ClearAll()
Private Sub Form_Load()
Private Sub ExitBtn_Click()
Private Sub SaveBtn_Click()
Private Sub SearchBtn_Click()

Private Sub CancelBtn_Click()
Private Sub EditBtn_Click()
Private Sub DeleteBtn_Click()

Note : You will need 2 Pictures PNG [On : Off] to refer to the Database Status, path [..Bin/Debug].

Another Lesson : How to Remote Database using XML :

1) Create an XML file in path [.\bin\Debug\] Folder and call it [XmlFile.xml]
2) Open [XmlFile.xml] with NotePad.exe and paste the following code into it :

3) Save the Xml file.
4) Open our VB 2010 Project and add a ToolStrip to the Form1, Dock = Buttom
ToolStrip VB 2010 Xml Database Update
ToolStrip VB 2010 Xml Database Update
5) How does it work "The Main Idea" : When you want to Alter structure or Edit the Advantage Database of your Advantage Database "DB.Add" on a Client's "User's" computer you will need to do something like what I did, easy and guaranteed. Find a Server and send SQL Statements to the Xml File and when the user checks for update [Check For Update] button, the application will open the XmlFile.xml and execute the Sql-Statement within, simply like that. When you use Version Number along with the update, it makes the Update process so easy to be tracked, so we will need to create and extra Database Table in the Advantage Database and call it [DB_Version].
6) DB_Version table structure :
Update Advantage Database [MyDB.Add] using XML and Visual Basic 2010
Update Advantage Database [MyDB.Add] using XML and Visual Basic 2010
Note : UpdateDT column is Date DataType.
7) Now each time you send updates to XML file, the user Checks for update and choose the XML file from Open Dialog Box and it compares the Date and Version of the Update, if New then it executes the Sql Statement line, if not, then it gives message [MsgTxt.Text] You're Up-To-Date.
8) Download Example from MediaFire.com [Testing.ZIP]

AdsConnection GetSchema tip :

How to retrieve Advantage Data Dictionary Schema in VB 2010.
VB 2010 GetSchema - Retrieve Tables, Columns From Ads Data Dictionary (AdsConnection)

Advantage DataTypes conversion in VB 2010

Type

Length

Available in DBF Table

VB 2010 Value

Character
1 to 65530
Yes
4
CICharacter
1 to 65530
No
20
Date
4
Yes
3
Logical
1
Yes
1
Memo
9
Yes
5
Double
8
VFP, Extended
10
Integer
4
VFP, Extended
11
Numeric
2 to 32
Yes
2
Image
9
Extended
7
Binary
9
Extended
6
ShortInteger
2
No
12
Time
4
No
13
TimeStamp
8
No
14
AutoIncrement
4
No
15
Raw
1 to 65530
No
16
CurDouble
8
No
17
Money
8
No
18
ModTime
8
No
22
RowVersion
8
No
21

Best Use, For example :
When you try to Retrieve Advantage Data Dictionary Table Structure you will get column names, and you will may need to retrieve Data Types [Field_Type], Advantage Data Arc. provides System.Columns Field_Type column within the System.Columns Table that return values like [Character], now when you do that in Visual Basic 2010 or any Visual Basic .Net version, you will not get [Character] but you will get [4] instead and you will want to convert it into [Character] name, you can do that using a function or a Select Case expression in VB 2010.
So, in order to retrieve Field_Type or DataType of a certain column in Advantage Database, you may use this code:

Some Exceptions and Errors noticed :

Error : 
Table doesn't appear in the Data Dictionary [ARC.exe] but though it appears in the Data Dictionary Folder.
Description :
When you try to create a free Table [ADT Table] using Sql Statement from VB 2010 like this. The result will be a free Table but not included in the Data Dictionary, but you will only see it in the Folder contains the Database.
Cause :
The User Id section in the connectionString is Empty, but if you tried to create another table with the same name you will get an Error specifying that ISAM found a table with the same name "Table already exists" though it doesn't appear in the Data Dictionary.
Solution :
Provider a User ID or a User Id and Password if possible in the connectionString Whether you are using OleDBConnection or AdsConnection to work with this Data Dictionary.

Here are some online Visual Basic lessons and courses :

Sunday, August 11, 2013

Visual Basic Online Course FlexGrid

Visual Basic 2010 - FlexGrid

Visual Basic 2010 FlexGrid
Visual Basic 2010 FlexGrid
The Microsoft FlexGrid (MSFlexGrid) control displays and operates on tabular data. It allows complete flexibility to sort, merge, and format tables containing strings and pictures. When bound to a Data control, MSFlexGrid displays read-only data.

You can put text, a picture, or both, in any cell of an MSFlexGrid. The Row and Col properties specify the current cell in an MSFlexGrid. You can specify the current cell in code, or the user can change it at run time using the mouse or the arrow keys. The Text property references the contents of the current cell.

If the text in a cell is too long to display in the cell, and the WordWrap property is set to True, the text wraps to the next line within the same cell. To display the wrapped text, you may need to increase the cells column width (ColWidth property) or row height (RowHeight property).

Use the Cols and Rows properties to determine the number of columns and rows in an MSFlexGrid.

Note : Before you can use an MSFlexGrid in your application, you must add the MSFlxGrd.ocx file to your project. To automatically include the file in your project, put it in the Autoload file. When distributing your application, you should install the MSFlxGrd.ocx file in the users Microsoft Windows System directory. For more information about adding an ActiveX control to a project, see "Standard ActiveX Controls" in the Visual Basic Programmers Guide.

How to add a FlexGrid component to Visual Basic .Net Form ?

- MSFLXGRD.OCX is a COM not a Net component but it can be added to a .Net Form in Visual Basic 2010 and work with it. In order to do so :

1) Open Visual Basic 2010 - New Project - Windows Form Application
Visual Basic 2010 Online Courses Free
Visual Basic Windows Form Application
2) Make sure you are displaying the design mode of the Form1.vb, to be able to choose components
Visual Basic 2010 online courses free
Visual Basic 2010 Form Design Mode
3) From Tools at the left side of the form, right-click anywhere and there will be a list, choose [Choose Items....]




Visual Basic Online Courses
Visual Basic 2010 Tools - Add FlexGrid
4) You will notice a new dialog box is opened where you get to pick up .Net components and Com components, click on the Tab with COM Components, then navigate to [Microsoft FlexGrid Control].

FlexGrid in VB2010 .Net
Visual Basic 2010 - Adding FlexGrid to Form
5) Click OK. Now from Tools, navigate to the end of the current section and you will file [Microsoft FlexGrid Control], just drag it on the Form or Double-Click it to be placed automatically on the Form
Visual Basic Online Courses
FlexGrid in VB2010 .Net Form
6) Now you successfully placed a COM component on .Net Form. Visual Basic 2010 will automatically convert this COM component into .Net component when Building your application.

Here are some online Visual Basic lessons and courses :

Monday, July 01, 2013

Visual Basic Online Course OOP Classes

Visual Basic Application Development
Object Oriented Programming 

Introduction

After creating so much applications and working with Databases, I was always afraid of getting close to OOP (Object Oriented Programming). OOP is the essence of Programming languages, understanding OOP is a sign which tells you "You are a talented programmer". 

We all know that there is a difference between programming practitioner and freelancer programmer, some say that practitioners are much secure, they don't need to learn more to get paid because they already have a job, but a freelancer is a guy who is talented in something (In this example : Programming) and in addition he/she wants to make something out of it.
VB 2010 OOP
VB 2010 OOP
OOP or Object Oriented Programming, means programming the programming, Yes! Before studying OOP we used to write codes and place tools, then hoke them up together to come up with something magnificent for ourselves or for our clients for money or some school degrees as a project.

No client will ever ask you to create a programming tool for him, or to modify a built-in tool for him, unless he is another programmer trying to sell something over the internet, if you ever worked in a freelance agency such as for example Freelancer.com, Odesk.com or Vworker.com those and others are major hiring websites for freelancers, not just in programming field but in so much things.

Each and every desktop application written and designed in Visual Basic .Net includes for most of us, basic interfaces : The form, the controls on the form, coding the controls, packing all above, to come up in the end with an application, well this is not exactly how it works in OOP programming.

In OOP programming you create your own everything from scratch to start using it in your form or coding controls on the form or creating controls (TextBoxes, Labels, ..... etc.) for yourself for later work. OOP is written within a Class.

Since .Net Framework started, and almost everything in Visual Basic became a separate Class of its own. Notice when you open the form to write a code, the first line says (Public Class Form1) then in the end (End Class).

A Class is the mother and the father of each and single object in Visual Basic .Net, everything you see in Visual Basic .Net came from a Class. To create a Class, you need to need to create a Class, I'm not kidding, I mean it, if you want to create a Class in your project then you must need one unless it won't make any sense, since logic is key stone and the only motivation for programmers to start designing coding, and Classes is one of those jobs as designing and coding then logic (The need for creating a Class) must be present in order to succeed and make sense.

VB 2010 OOP
VB 2010 OOP

When do we need to create a Class for our Visual Basic .Net Project ?

If you are trying to create your own Textbox or label, or if you are generally trying to create your own Visual Basic .Net Control, then you are definitely in need for a Class, as a result, you need to know OOP.

If you developed a method with a 3rd party for example, and you need to always include this method in further applications, then you need to create a Class for yourself, and also as a result you will have to learn and read about OOP.

Last thing, the basic thing to need to create a Class is when you are trying to contain your code blocks into a container for further development, then you need a Class.

VB 2010 OOP
VB 2010 OOP
Yes, all we need now is an example of a Class to start working. See you next chapter.

Here are some online Visual Basic lessons and courses :

Friday, June 21, 2013

Visual Basic Online Course The following control could not be licensed: TxTextControl.TextControl

The following control could not be licensed: TxTextControl.TextControl

Search Optimization, Word Processing Integration
Tx TxtControl, powerful tool for VB2010 that enhances Word Processing Integrations

How to compile a specific license (*.licx) file to your Visual Basic 2010 project for example the [Tx TxtControl] Object. Tx TxtControl is an evaluation product and can be downloaded from here, unless you register the product with a standard license, it will not work properly with Visual Basic 2010

Tx TxtControl is a Visual Basic .Net powerful tool that enable you to create a Word Processing Integration form to enable the user to take notes and save it and retrieve it. With Tx TxtControl you can do the following :
  • Integrate comprehensive word processing into your Windows applications
  • Load, edit and save Microsoft Word formats (DOCX, DOC, RTF etc.)
  • Build powerful reporting and mail merge applications
  • Load, edit and create Adobe PDF documents
  • Completely royalty-free
The problem is that the Eval. Version pops up a message in the IDE and the Run-Time and generate an error message :
The following control could not be licensed: TXTextControl.TextControl
Visual Basic .Net 2010 Tx TxtControl Cracked
Tx TxtControl License Problem in Visual Basic .Net (VB2010)
To solve the Tx TxtControl license problem, you need to do the following :
1) Add Reference to Tx TxtControl in your Visual Basic 2010 Project
Visual Basic 2010 Online Courses and Solutions
Add Reference to Tx TxtControl in Your VB2010 project
2) A 'licenses.licx' file must exist in the 'My Project' folder. To build such a file, create a new text file in this folder and name it 'licenses.licx'. Open the file and add the following string: 
TXTextControl.TextControl, TXTextControl, Version=13.0.500.500, Culture=neutral, PublicKeyToken=6b83fe9a75cfb638
The 'licenses.licx' file is not a TX Text Control specific file, but a Visual Studio file that is used by 'lc.exe' (which is part of the .NET SDK) to compile the licenses into the assembly. These above steps are done automatically, if you drag and drop a TextControl from the toolbox onto a form.

The above line that refers to the License will vary from version to another. To find the proper License file for the existing Tx TxtControl Version for VB.Net WinForms :

  • Go to the C:\ drive and locate the installation folder for Tx TxtControl
  • You will find the License for the current version most likely here :
    C:\Users\User_Name\Documents\TX Text Control 19.0.NET for Windows Forms\Samples\WinForms\VB.NET\TX Text Control Words\My Project
  • You will find the License.Licx file placed there
  • Open it, copy the contents
  • Open your Visual Basic 2010 Project. Folder [My Project] add *.txt file and call it License.Licx if it is not already there and paste the previous copied lines
  • [If you found License.Licx there already, just open it with NotePad and add the following to the end of it]
  • Save all you work, Build Solution for your Project.
Here are some online Visual Basic lessons and courses :

Wednesday, June 19, 2013

Visual Basic Online Course Search Optimization

dtSearch Engine
Using dtSearch Engine to Create Search Optimization via Visual Basic 2010

Create Visual Basic .Net Search Optimization tool using dtSearch Engine to :

 Optimize Search
Index files
Search Index
Retrieve Search Results
Highlight Search Results
dtSearch Engine : Powerful tool can be downloaded from its official website. There is the dtDeskTop Search and dtSearch Engine for developers, we need the last one to be downloaded. You will be given a password to install the Eval. Version of dtSearch Engine by the customer support team via Email or via SkyPe. I recommend downloading the dtSearch Engine 772.

After installing dtSearch Engine successfully on your machine, you will find the files in the C:\ drive and Start Menu. Restart your machine.
Search Optimization
dtSearch Engine - installed files
There will be VB.Net examples in the C:\ drive cover most of the supported programming languages by the dtSearch Engine Tool including VB.Net 2010 [.Net frameWork 4] in this folder (C:\Program Files\dtSearch Developer\examples\vb.net4).

dtSearch Engine mechanism goes like this :

  • Create Indexes (If exists, then you can update the existing Index)
  • Add Files to be Indexed
  • Search Index
  • Retrieve Search Results (Highlight search results)

From Visual Basic .Net 2010

In order to use dtSearch Engine within VB2010 you will need :
      1. Create new Visual Basic 2010 Project
      2. Add dtSearch Engine Reference Files.
dtSearch Engine Reference Files to be added to the VB2010 project, are :
dtSearch Engine Optimization via Visual Basic .Net
dtSearch Engine via Visual Basic .Net (framework 4.0)
Not only searching System Files but also you can Search Database using the same mechanism (Create Index, Add Resources to Index, Search Indexed Resources, .... ,etc.)
Here is a source code example well detailed and explained of How to use dtSearch Engine to Optimize Search "Optimization" via VB.Net 2010 and .Net framework 4.0.

Using dtSearch Engine in Visual Basic .Net 2010 [Source Code Example] :
(1) dtSearch Engine - Logic and Design
(2) dtSearch Engine - Indexing/Searching local Files

Here are some online Visual Basic lessons and courses :

Friday, June 14, 2013

Visual Basic Online Course DevExpress 12.2.4 full for Visual Studio 2010

Your next great app. Your way.

From interactive Desktop applications, to immerse Web and Mobile solutions, tools to meet your needs today and ensure your continued success tomorrow. 

Download DevExpress from its main WebSite
Download Dxperience full

Password : evry1.net/VBNet

DevExpress is a very powerful tool for Microsoft Visual Studio 2010 and any Visual Studio starting VS2005 until VS2012. From the above 4Shared.com Widget you can download DevExpress 12.2.4 freely, the uploaded files contain the registration for free Dll leaked [dxv2_regaddin.12.2.4]. The download should be merged in one folder and the 3 parts of Dxperience should be all downloaded and extracted [Merged] in the same folder.

After downloading

♦ Extract the 3 files :
♠ Devexpress-12.2.4-by-evry1.net.part1.rar 
♠ DevExpress-12.2.4-by-evry1.net.part2.rar
♠ DevExpress-12.2.4-by-evry1.net.part3.rar
into one folder, you will find 2 files after extraction [DevExpress 12.2.4 and  dxv2_regaddin.12.2.4].
♦ Double-click the Devexpress 12.2.4 exe file and install Dxperience 12.2.4, you may also choose [Trial Version] for now.
♦ After installation completed, restart your machine.
♦ Make sure VS 2010 loads DevExpress 12.2.4 correctly
○ DevExpress 12.2.4 is in the Menu Bar in VS2010
dEVeXPRESS 12.2.4 FULL SERIAL CRACK
 ○ DevExpress 12.2.4 is in the Projects Box in VS2010
dEVeXPRESS 12.2.4 FULL SERIAL CRACK
 ○ DevExpress 12.2.4 is in the Tool Box in VS2010
dEVeXPRESS 12.2.4 FULL SERIAL CRACK

 ♦ Then after making sure the VS2010 loads Dxperience [DevExpress 12.2.4] correctly like in the previous photos, launch the file [dxv2_regaddin.12.2.4.exe] and install it.

♦ You are now enjoying the free full cracked DevExpress 12.2.4.

☺ If you decided to upgrade your DevExpress 12.2.4 to DevExpress 12.2.6 or DevExpress 12.2.9 I strongly recommend not to remove the previous version installed and working already.

Announcing DevExpress 13.1

Our Newest Release for .NET Developers

Glendale, California — June 6, 2013 — DevExpress is proud to announce the immediate availability of DevExpress Universal 13.1, a fully integrated software development toolset for .NET developers. From WinForms, ASP.NET and HTML 5 to WPF, Silverlight and Windows 8 XAML, DevExpress Universal allows you to build your best, see complex software with greater clarity and to create stunning Windows, Web and Mobile applications in the shortest possible time.
New for WinForms Developers
DevExpress 13.1 now ships with the following new controls and features:
  • New Spreadsheet Control
  • New Map Control
  • New Data Editors, including Sparkline and drop down Tree-List
  • New Icon Library
  • New Windows 8 Live Tile Manager for WinForms apps.
  • New Touch-Optimized Skin
  • New PDF Viewer Control (preview release)
  • Improved Design-Time Experience
Learn more:
New in WinForms 13.1

Here are some online Visual Basic lessons and courses :

Wednesday, June 12, 2013

Visual Basic Online Course - The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

MS-Access 2010 for VB 2010
MS-Access 2010 for VB 2010
Visual Basic 2010 Error Message :
InvalidOperationException was unhandled
" The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine" ?
This error message means that the machine [Computer, Laptop] that you are trying to run your application on, doesn't have MS-Access 2007 installed, or not installed properly. Some developers just pack their applications and send it to the client :
- relying on - that the client have MS-Office 2007/2010 installed already and won't never crash or updated to 2010, 
- or they just did not include the proper component along with their package, 
- or even worse they may not know what exactly should they do to make it work on the client's machine.

╚Ž╣ To get this error message to go away, you need to include this file in your package :

2007 Microsoft Office System Update: Redistributable Primary Interop Assemblies

 Some think that Office 2007 should be installed on a client's machine in order for the application to run clean or properly with any bugs, No, you can include this tool for both [Win32 and Win64] and don't count the client to have Office installed or not.

Get the file from here [AccessDatabaseEngine] for both Win64bit and Win32bit, available in all languages supported by Microsoft. Here are some information about downloading and installing the tool :

When you first click on Download on the Download page, you will see :

Choose the download you want

File Name

AccessDatabaseEngine.exe    25.6 MB
AccessDatabaseEngine_x64.exe    28.1 MB

The download should start for selected file ...
Office

Thank you for downloading

The 2007 Microsoft Office system Primary Interop Assemblies (PIA) redistributable is a Microsoft Windows Installer package that contains the Primary Interop Assemblies for 2007 Microsoft Office system products.

 You could see a reference to Office 2010, don't panic, this is the same, it's the same tool that supports also Office 2010. If your application relies on MS-Access 2010 Database and you got the same meaningful Error message then the same cause needs to be fixed by including this very same file into your package without relying on the client's machine to have MS-Office 2010 or MS-Access 2010 installed on it.

Thank you for downloading

  • Microsoft Access Database Engine 2010 Redistributable

    After the download finishes, pick up the corresponding file that meets your OS kind [32 or 64]

    ♥ Installation Instructions ♥

    To install this download:
    1. Download the file by clicking the Download button and saving the file to your hard disk.
    2. Double-click the AccessDatabaseEngine.exe program file on your hard disk to start the setup program.
    3. Follow the instructions on the screen to complete the installation.
    To use this download:
    1. If you are the user of an application, consult your application documentation for details on how to use the appropriate driver.
    2. If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”

      If you are connecting to Microsoft Office Excel data, add the appropriate Extended Properties of the OLEDB connection string based on the Excel file type:

      File Type (extension)                                             Extended Properties
      ---------------------------------------------------------------------------------------------
      Excel 97-2003 Workbook (.xls)                                  "Excel 8.0"
      Excel 2007-2010 Workbook (.xlsx)                             "Excel 12.0 Xml"
      Excel 2007-2010 Macro-enabled workbook (.xlsm)      "Excel 12.0 Macro"
      Excel 2007-2010 Non-XML binary workbook (.xlsb)      "Excel 12.0"

    3. If you are an application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”
    4. If you are an application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”
    To remove this download:
    To remove the download file itself, delete the file AccessDatabaseEngine.exe
    1. On the Start menu, point to Settings and then click Control Panel.
    2. Double-click Add/Remove Programs.
    3. In the list of currently installed programs, select “Microsoft Access database engine 2010” and then click Remove or Add/Remove. If a dialog box appears, follow the instructions to remove the program.
    4. Click Yes or OK to confirm that you want to remove the program.  

     

    Additional Information


      This package contains components that are at the same version as the “The 2007 Microsoft Office Suite Service Pack 1 (SP1)” release.

      The Office System Drivers are only supported under certain scenarios, including:

      1. Desktop applications which read from and write to various files formats including Microsoft Office Access, Microsoft Office Excel and text files.
      2. To transfer data between supported file formats and a database repository, such as SQL Server. For example, to transfer data from an Excel workbook into SQL Server using the SQL Server Import and Export Wizard or SQL Server Integration Services (provided the SSIS jobs run in the context of a logged-on user with a valid HKEY_CURRENT_USER registry hive).
 Source for Installation instruction (Microsoft)

Here are some online Visual Basic lessons and courses :

Visual Basic Courses - Share