Results 1 to 4 of 4

Thread: Import/Export

  1. #1
    Join Date
    Oct 2004
    Posts
    2

    Unanswered: Import/Export

    Hello... Iam still a newbie in SQL but have to learn it anyway (as fast as possible tbh)

    Are there any SQL Commands for exporting a table from an access db and import it into another existing access db?

    Cheers
    Grenzer

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    look under the File item on the main menu, and choose either
    - Get External Data > Import
    - SaveAs/Export
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2004
    Posts
    2
    That´s the way Iam doin it in access.

    Iam running an ASP page and want to import a table of one access database into my existing database. I dont want to download the complete database, edit and upload it again. What I wanna do is to add a SQL command my ASP page which would do this export/import!

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    try this:

    insert into database1.tableX (col1, col2, col3)
    select expr1, expr2, expr3 from database2.tableY
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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