Results 1 to 3 of 3

Thread: data transfer

  1. Oct 7th, 2002, 01:06 PM #1
    spud
    spud is offline

    Thread Starter
    Fanatic Member spud's Avatar
    Join Date
    Aug 2000
    Location
    Munster (Germany)
    Posts
    542

    Question data transfer

    Hi

    I have a two database's (Access) with the same field's in both, wat i would like to do is trensfer the data from on to the other.

    Is this posible?

    Tried a search but I come up with a few thousand entries!

    Thx
    Haven't got anything to say that is the least bit interesting.
    www.tartan-underground.com
    Reply With Quote Reply With Quote
  2. Oct 8th, 2002, 04:01 AM #2
    Gaffer
    Gaffer is offline
    Fanatic Member Gaffer's Avatar
    Join Date
    Nov 2000
    Location
    London
    Posts
    828
    Do you want to do it as a one off, or part of a regular e.g. daily process?
    Reply With Quote Reply With Quote
  3. Oct 8th, 2002, 04:02 AM #3
    JMvVliet
    JMvVliet is offline
    Hyperactive Member JMvVliet's Avatar
    Join Date
    May 2001
    Location
    Papendrecht, Netherlands
    Posts
    310
    It must be possible.

    Most easy way is:

    -Link the needed table from databaseB into databaseA.
    -From there, you can make a query that does the hard job for you.

    INSERT INTO [tbl_from_a] SELECT * FROM [tbl_from_b]

    where tbl_from_a means the destination table, and tbl_from_b means the data that was coming from another database
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width