Results 1 to 4 of 4
  1. #1
    je13fr is offline Novice
    Windows 10 Office 365
    Join Date
    Apr 2021
    Posts
    2

    How to make it smart from excel to Access

    Hello Dear Reader,



    I post on DB design because I'd like to get your experience and habits migrating Excel spreadsheets to Access.

    From my side I have several huge spreadsheets and in Access I believe we should leverage relation.

    Help is welcome

    Thanks
    Jerome

  2. #2
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    1,677
    I'd have a read here
    https://www.niftyaccess.com/excel-in-access/

    Tony has some excellent articles on the conversion of spreadsheet > access
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    je13fr is offline Novice
    Windows 10 Office 365
    Join Date
    Apr 2021
    Posts
    2
    Quote Originally Posted by Minty View Post
    I'd have a read here
    https://www.niftyaccess.com/excel-in-access/

    Tony has some excellent articles on the conversion of spreadsheet > access
    Thanks, very interesting

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,691
    Post 3 was moderated, I'm posting to trigger email notifications.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Smart Database
    By jwallace in forum Database Design
    Replies: 2
    Last Post: 12-19-2015, 08:11 AM
  2. is this smart form possible?
    By ariansman in forum Access
    Replies: 3
    Last Post: 11-10-2014, 02:48 PM
  3. Replies: 0
    Last Post: 05-11-2012, 08:11 AM
  4. Smart Card error
    By Ashe in forum Forms
    Replies: 2
    Last Post: 10-17-2011, 03:22 PM
  5. Need a 'smart' field
    By doci4a in forum Programming
    Replies: 5
    Last Post: 03-04-2011, 09:43 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums