Re: Macro to inport excel file to table in access 2007

Discussion in 'Microsoft Access Macros' started by Ken Snell [MVP], Jul 23, 2009.

  1. Use TransferSpreadsheet macro action. It has arguments into which you can
    put constants that identify the file name with path, etc.

    --

    Ken Snell
    <MS ACCESS MVP>
    http://www.accessmvp.com/KDSnell/


    "Leanne" <> wrote in message
    news:...
    > Hello there
    >
    > I'm trying to create a macro to import an excel file that regularly needs
    > importing.
    >
    > How can i create a macro that will import the same file without having to
    > find the file location each time the macro is run and without having to
    > enter
    > that it is to append a table that already exists?
    >
    >
     
    Ken Snell [MVP], Jul 23, 2009
    #1
    1. Advertisements

  2. Ken Snell [MVP]

    Leanne Guest

    TransferSpreadsheet isnt showing in the drop down list for macro action

    In the help files it is menioned but it isnt showing. is there a reason for
    this?

    "Ken Snell [MVP]" wrote:

    > Use TransferSpreadsheet macro action. It has arguments into which you can
    > put constants that identify the file name with path, etc.
    >
    > --
    >
    > Ken Snell
    > <MS ACCESS MVP>
    > http://www.accessmvp.com/KDSnell/
    >
    >
    > "Leanne" <> wrote in message
    > news:...
    > > Hello there
    > >
    > > I'm trying to create a macro to import an excel file that regularly needs
    > > importing.
    > >
    > > How can i create a macro that will import the same file without having to
    > > find the file location each time the macro is run and without having to
    > > enter
    > > that it is to append a table that already exists?
    > >
    > >

    >
    >
    >
     
    Leanne, Jul 23, 2009
    #2
    1. Advertisements

  3. You need to "Show All Macros". See this help article for more information.
    http://office.microsoft.com/en-us/access/HA012142021033.aspx

    --

    Ken Snell
    <MS ACCESS MVP>
    http://www.accessmvp.com/KDSnell/


    "Leanne" <> wrote in message
    news:...
    > TransferSpreadsheet isnt showing in the drop down list for macro action
    >
    > In the help files it is menioned but it isnt showing. is there a reason
    > for
    > this?
    >
    > "Ken Snell [MVP]" wrote:
    >
    >> Use TransferSpreadsheet macro action. It has arguments into which you can
    >> put constants that identify the file name with path, etc.
    >>
    >> --
    >>
    >> Ken Snell
    >> <MS ACCESS MVP>
    >> http://www.accessmvp.com/KDSnell/
    >>
    >>
    >> "Leanne" <> wrote in message
    >> news:...
    >> > Hello there
    >> >
    >> > I'm trying to create a macro to import an excel file that regularly
    >> > needs
    >> > importing.
    >> >
    >> > How can i create a macro that will import the same file without having
    >> > to
    >> > find the file location each time the macro is run and without having to
    >> > enter
    >> > that it is to append a table that already exists?
    >> >
    >> >

    >>
    >>
    >>
     
    Ken Snell [MVP], Jul 23, 2009
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Macro Builder

    How do you invoke an Excel macro from an Access macro?

    Macro Builder, Sep 29, 2003, in forum: Microsoft Access Macros
    Replies:
    2
    Views:
    6,637
    Ken Snell
    Sep 30, 2003
  2. Guest

    run excel macro from access macro

    Guest, Oct 29, 2004, in forum: Microsoft Access Macros
    Replies:
    0
    Views:
    378
    Guest
    Oct 29, 2004
  3. Guest

    run excel macro from access macro

    Guest, Oct 29, 2004, in forum: Microsoft Access Macros
    Replies:
    0
    Views:
    340
    Guest
    Oct 29, 2004
  4. Guest

    Run an excel macro from an access macro

    Guest, Oct 29, 2004, in forum: Microsoft Access Macros
    Replies:
    0
    Views:
    300
    Guest
    Oct 29, 2004
  5. pele

    Macro to delete Table - table lock message by Access

    pele, Apr 20, 2005, in forum: Microsoft Access Macros
    Replies:
    2
    Views:
    1,007
  6. Guest
    Replies:
    2
    Views:
    4,604
    Elijah Taylor
    Feb 21, 2007
  7. RC
    Replies:
    0
    Views:
    461
  8. Craig
    Replies:
    1
    Views:
    7,221
    Ken Snell MVP
    Mar 14, 2009
Loading...