move data from one database to another

I have 2 databases... One on my remote web server.... and one on my local hard drive.... I need to take recordsets from my local hard drive and add them to my database on my remote web server... What i was planning on doing is just open a connection to both and start looping through the recordsets on my computer and creating a query to add it to the remote database... Is there  abettter way of doing this? HOW DO I CONNECT TO A REMOTE DATABASE????
Gunit2507Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sasidar_dCommented:
Hi
You can connect to the remote server just by giving the ip in the connection string
u will be having the connection string as
"server=localhost"
instead of "localhost" u can give the ip of the remote server

Hope by this u will be able to connect to the remote server

Happy Programming
RejojohnyCommented:
what database is this? SQL server? do u have permissions to make remote connection using IP .. if yes, is this a one time job? If yes, then use SQL server's DTS .. its much eaiser and faster .. also provides u with a good wizard ..
samtran0331Commented:
I agree with Rejojohny, DTS is the way to go...but just to clarify something...they aren't just for 'one time jobs'..DTS's can be scheduled to run.
Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

Gunit2507Author Commented:
is a MS access database

Do you have an example connection string?
RejojohnyCommented:
both r MS access? is the source is MS access and destination is SQL server, u could still use DTS .. if this has to be done programitacally, u could create a package of the import process (DTS package) and call it programitaclly from ur code .. have a look here for more information and sample code .. www.sqldts.com
Gunit2507Author Commented:
the destination is not a SQL server
RejojohnyCommented:
have a look at this link for all types of connection strings ...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RejojohnyCommented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.