Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005
    Posts
    73

    Red face Unanswered: Merge Access and Excel tables

    Hihi guys,

    Anyone has any ideas how to merge excel tables with access tables..

    Heard some advice to write a script and sthg to do with ODBC as such.. but dun really noe the way to do it.. well.. im having trouble for it for three weekss... please help please help...

    I cant do importing cos the excel spreadsheet is totally different frm the access table!! Arrr.. help me!!

    Sometimes one field in access table is equivalent to 3fields in Excel table...


    DoubleThanks,
    blurblur gal

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    you could just link your excel table and then run an append query, but without knowing what you want to do i cant be of any more help

    Dave

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Quote Originally Posted by shanshan
    Sometimes one field in access table is equivalent to 3fields in Excel table...


    DoubleThanks,
    blurblur gal
    Your issue isn't technical, it's conceptual. What are the layouts of both tables?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    Hi BlurBlur Girl

    In responce to your PM asking what additional information needed
    as teddy says what you need to do is provide us with table structure what relationships build up your data from your excel sheet maybe then we can build up some SQL that will let you do what you need to do i.e. an append query

Posting Permissions

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