| Author |
 Topic  |
|
|
drastixnz
Starting Member
New Zealand
3 Posts |
 Posted - 07/21/2012 : 04:07:44
|
Hello all and thanks in advance, for the help.
I have two databases both access called the following
1) estimator private.mdb (which is live on a system)
2) working_database.mdb (which is offline, so data can be worked on)
they both have one table in common, this is what I am wanting to do I am wanting to take one row, of data from the first database Number (1) and copy into another database number (2).
Help how cando this via SQL command.
Thanks for the help in advance. email me or post to me please
paul@mycomputerguy.net.nzpaul@mycomputerguy.net.nz |
|
|
sunitabeck
Flowing Fount of Yak Knowledge
5152 Posts |
Posted - 07/21/2012 : 08:01:29
|
Are you trying to do this while you are working in a SQL Server database, or do you only have the two access databases?
If you are working from a SQL Server, you can use SSIS (SQL Server Integration Services) or even Import/Export Wizard. To use Import/Export wizard, right click on a database name in SQL Server, Tasks -> Import Data and follow through the wizard.
If you are working without a SQL Server - i.e., you have only two access files, this page gives you the information: http://office.microsoft.com/en-us/access-help/import-or-link-to-data-in-another-access-database-HA001227658.aspx The link to "Import data from another Access database" on that page has step-by-step instructions. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47173 Posts |
Posted - 07/21/2012 : 11:54:44
|
If you dont have need to use SQL server in between I think you should be following latter method Sunita suggested. There's no need of using SSIS/linked server etc in that case.
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
drastixnz
Starting Member
New Zealand
3 Posts |
Posted - 07/21/2012 : 18:01:01
|
Thanks for the help so far, i dont think I have explained my self fully.
Database (1) is in a live system i want to export data via a program interface, to database (2) the program interface need the SQL command to achive this |
|
|
|
sunitabeck
Flowing Fount of Yak Knowledge
5152 Posts |
Posted - 07/22/2012 : 06:35:25
|
What kind of program interface are you using? If it is .Net code, then you can use ADO.Net to connect to the source database, retrieve the records from there and connect to the target database, again using ADO.Net and write the records to the target database.
There are examples here in C# and VB.Net for Northwind Access database: http://msdn.microsoft.com/en-us/library/dw70f090.aspx
If you are using something other than .Net (such as Java, Perl etc.), you would use the appropriate libraries/packages to connect to the database. If you google for the language name + Access database, you will find examples. |
|
|
| |
Topic |
|
Sql Insert
