Copying rows from one Access database to Another using Query

In access database, we can copy rows from one table to another using query. How can we transfer rows from one database to another?

Using the in  keyword in Insert statement we can specify an external database path as follows in access query

insert into Account_Transactions(Date ,Name ,Type ) in 'D:\Sherpharma\T.mdb' select  Account_Transactions.Date,Account_Transactions.Name,Account_Transactions.Type from  Account_Transactions
Here we copy the rows from current database to the T.mdb files. We can also use this query in programming as well.

Comments

Post a Comment

Popular posts from this blog

How to get Computer Name using VB6 Code

Accessing system property is pretty easy with VB6 code. This can be useful when programmers need to refer the system name in the code. Steps Declare the GetComputerNameA function which resides in the kernel32 library. Create a function to fetch the Computer Name. Use the function The Kernel functions Declare Function GetComputerNameA Lib "kernel32" (ByVal lpBuffer As String, nSize As Long) As Long Get the computer name Define a new function to do the rest of the task. So you can reuse the code. Public Function GetComputerName() As String Dim sResult As String * 255 GetComputerNameA sResult, 255 GetComputerName = Left$(sResult, InStr(sResult, Chr$(0)) - 1) End Function Calling the function Just invoke the function and place values to a TextBox Text1.Text = GetComputerName
Read more

How to Flask with Python : Making of a Flask website

Flask is the one of the most popular Micro Framework which enables programmers to quickly build web applications. Linkedin, Pinterest are some of the finest examples of this framework. The Framework was initially coded by Armin Ronacher of Pocoo. Let's start with Installation Install Flask First up all you need to install Python on your system if you don't have to get one from www.python.org. You can install Flask from Python Package Index which requires the PIP command and an internet connection. Learn how to get PIP? Install flask using the following command line, the simplest way to install Flask on your system. On Windows go to your command prompt/shell and issue the pip command. D:/> pip install flask It will take some time to finish the procedures. Uninstalling Flask D:/> pip install flask will remove Flask packages from your system Create your first App Flask is Fun Create a file called hello.py from flask import Flask app =...
Read more

OLEDB Database connection string in C#.Net

OledDb database connections allow C# developers to build data powered applications with Access database. It can be possible with Database connection object and command object. Connection string  For connecting .mdb Access files you can use the following connection string, string connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:/.Net Project/PharmaERP/PharmaERP/PharmaData.mdb"; and for the Access 2007, 2012,2016 databases you have to use the following one. string connstr = "Provider=Microsoft.ACE.OLEDB.12.0;;Data Source=D:/.Net Project/PharmaERP/pharmaData.accdb;Jet OLEDB:Database Password=password";  Now we are ready to setup the connection, let build the connection objects and get started. Connecting database with OleDbConnection object.     OleDbConnection conn; OleDbCommand Rs; public void Connect() { conn = new OleDbConnection(connstr); conn.Open(); } With the OleDbConnection o...
Read more