1. Welcome to TRD Forums! A community for Toyota, Lexus, and Scion Enthusiasts. To enjoy all the benefits of the site, we invite you to signup.

Tech Help with MicroSoft Access

Discussion in 'Off Topic' started by DjFrOsT, Apr 1, 2005.

  1. Offline

    DjFrOsT New Member

    Message Count:
    186
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Los Angeles
    Help with MicroSoft Access

    Hello ladies and gent...i'm working on this project at work...and i need to import some data into access...from and excel worksheet. I know how to import...that easy...but does anyone know how to automate that import?

    cause my boss said that a while back...and i mean a while back...there was a co-worker...that is no longer with our group...that created an access database that imported an excel worksheet automatically as soon as you hit the save button in the worksheet...

    does anyone know how to do this? if so...could you please post the process...

    thanks!
    DjFrOsT, Apr 1, 2005
    #1
  2. Offline

    DjFrOsT New Member

    Message Count:
    186
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Los Angeles
    thanks for the move admin...

    bump...
    DjFrOsT, Apr 1, 2005
    #2
  3. Offline

    1337Rolla oh my

    Administrator
    Message Count:
    3,979
    Likes Received:
    31
    Trophy Points:
    748
    this is the only free thing I could find
    http://www.autoitscript.com/autoit3/index.php
    you have to write scripts manually I think.. but it'll simulate mouse movements, typing etc that would copy the text over

    an alternative is to save a file as tab-delineated format then import that to access.. it usually has the best accuracy for getting the tables right.(only works with single sheet excel files though)
    1337Rolla, Apr 1, 2005
    #3
  4. Offline

    DjFrOsT New Member

    Message Count:
    186
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Los Angeles
    WOW...just readin the intro makes me want it...so i'm downloadin it...and i'll try it out...good lookin out with that find...WOW...i'll update later...thanks!
    DjFrOsT, Apr 6, 2005
    #4

Share This Page