Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Excel To Access

Discussion in 'Information Technology' started by Wills, Jul 28, 2006.

Tags:
  1. Wills

    Wills
    Expand Collapse
    Guest

    I am Currently using a multi sheet excel spreadsheet and want to export
    information from selected cells on individual sheets into Access creating a
    new record with each one. Any solutions ??
     
  2. Loading...

    Similar Threads Forum Date
    Canada Sukhdeep Kaur Chohan of Brampton Wins PM Award for Teaching Excellence Breaking News Mar 5, 2014
    India Sikh Regiment's Passion for Excellence Breaking News May 19, 2013
    Leisure Excellence -skills-Attitude Business, Lifestyle & Leisure Feb 14, 2010
    Katha Excellent Katha by Bhai Ram Singh Kathavachak Videos Aug 8, 2009
    [SPN] Celebrating Five Years of Excellence & Learning Announcements Jun 3, 2009

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Wills wrote:
    > I am Currently using a multi sheet excel spreadsheet and want to
    > export information from selected cells on individual sheets into
    > Access creating a new record with each one. Any solutions ??


    Many possible solutions.

    Many possible questions, like how are you going to identify the records
    you want and don't want to bring into Access?

    --
    Joseph Meehan

    Dia duit
     
  4. Rob Parker

    Rob Parker
    Expand Collapse
    Guest

    You don't explain anything about how your "selected cells" correspond to a
    record (a single entry in a table) in Access. As a first attempt, I'd
    suggest consolidating all the Excel cells you wish to export into a single
    sheet, and then use the TransferSpreadsheet method to import them into a
    table (either new or existing - in the latter case the fields must match) in
    Access.

    If you really want to do an import of randomly-selected cells from multiple
    sheets, it's will require lots of custom code in either the Excel workbook
    (as code to export to an Access database), or in an Access database (to
    import from the Excel workbook). Either way, it will require a detailed
    understanding of the Object Models of both Access and Excel.

    The first suggestion seems much simpler to me. If you require more details,
    please ask further.

    HTH,

    Rob

    "Wills" <Wills@discussions.microsoft.com> wrote in message
    news:B1904B0C-5A92-4BC9-AEEC-A1A5B81A2EC1@microsoft.com...
    >I am Currently using a multi sheet excel spreadsheet and want to export
    > information from selected cells on individual sheets into Access creating
    > a
    > new record with each one. Any solutions ??
     

Share This Page