Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Indiana, USA
    Posts
    79

    Question Unanswered: Import External Data

    After spending much time searching the archives I just have to ask. It's probably very simple but.....

    I want to automate the import of a specific table from a specific database (on my computer) when I open a page in my database so far I have -
    on the page's On Open event

    DoCmd.RunCommand acCmdImport

    I am trying to figure out how to tell it to import from Research.mdb (located in My Documents folder name Databases) a table named "needed stuff"

    I cannot tinker around with the original database because it's not my work - even with permission any updates to the program will overwrite my changes. so if I can import the needed information into my database, I can then manipulate the data
    Perplexed
    Eat a toad every morning and nothing worse will happen to you the rest of the day!

  2. #2
    Join Date
    Nov 2002
    Location
    Norway
    Posts
    239
    Create a link to the table on the external database.
    Run a “create table query” based on the linked table when you open your form.

    Sincerely
    Vestigo

  3. #3
    Join Date
    Feb 2004
    Location
    Indiana, USA
    Posts
    79

    Talking import

    Thank You,

    I thought it was something simple.
    Perplexed
    Eat a toad every morning and nothing worse will happen to you the rest of the day!

Posting Permissions

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