CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP.NET - InMotion Framework

 need to import data

Print topic Send  topic

Author Message
pjcltd

Posts: 34
Posted: 08/02/2012, 3:20 PM

Hi
i have 2 connections to 2 differant database's
connection 1 go's to a MS SQL server 2008

connection 2 go's to a MS Access Database

what i need to do is copy the records for a table from connection 2 into a table on connection 1

i need to be able to do this in code.

Both of the tables are the same format

SELECT SERVER, RID, BACKUP_ID_STATUS, POLICY, SCHEDULE, MEDIA_SERVER, MEDIA_ID_DESCRIPTION, copy_no, [TIME], [DATE], PRI_copy
FROM Data

thanks for the help in advance

thanks
Paul




View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.