Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Location
    Aarhus, Denmark
    Posts
    10

    Question Unanswered: import data from one table to another in .adp

    I'm working in a microsoft accecc project (.adp) database with sql-server.

    I would like to import data from one table into another table and I can see it can be done in a stored procedure. Anyone know how that is done?

    Rikke

  2. #2
    Join Date
    Jul 2002
    Posts
    7

    here ya go

    Try this in your sp:

    INSERT [destination table] ***you might want to specify fields here too
    SELECT [fields] FROM [source table]

Posting Permissions

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