Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

copy tables from one database to another


  • Please log in to reply
1 reply to this topic

#1 sandiyasubha

sandiyasubha

  • Members
  • 1 posts
  • OFFLINE
  •  
  • Local time:01:09 AM

Posted 29 January 2005 - 06:08 AM

hi,


i want to know how to copy tables from one database to another database in vb using ado

BC AdBot (Login to Remove)

 


#2 tos226

tos226

    BleepIN--BleepOUT


  • Members
  • 1,588 posts
  • OFFLINE
  •  
  • Gender:Female
  • Location:LocalHost
  • Local time:01:09 AM

Posted 30 January 2005 - 10:48 PM

I think you need to tell a bit more.
From where??? to where???
Are you copying tables from Oracle to Access? to SQL service?
From Access to Oracle? Access to Access?

If Access is in the picture, look in VBA help - there are some instructions there how to do it. Also in VB or VBA Help you'll find various object models where table is an object and copying is a method. Or you might get away with the import command (Access import/export) right inside Access.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users