Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
drastixnz
Starting Member
3 Posts |
 Posted - 2012-07-21 : 04:07:44
|
| Hello all and thanks in advance, for the help.I have two databases both access called the following1) 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 pleasepaul@mycomputerguy.net.nzpaul@mycomputerguy.net.nz |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-07-21 : 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
52326 Posts |
Posted - 2012-07-21 : 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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
drastixnz
Starting Member
3 Posts |
Posted - 2012-07-21 : 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
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-07-22 : 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. |
|
|
|
|
|
|
|
|
Sql Insert