Results 1 to 8 of 8
  1. #1
    saffar is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2020
    Posts
    5

    import excel to access based on student email

    I have a small database for marks i want to import excel file to access file based on student email
    the mark coloum is (Total points)

    e1 or any name i select) to exam1
    e2 or any name i select) to exam2
    e3 or any name i select) to exam3
    e4 or any name i select) to exam4
    e5 or any name i select) to exam5
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    1st, do prep:
    save as to the same file every time: c:\temp\File2Import.xlsx
    attach this file as an external linked table: tFile2Import
    build an append query to add this data to the internal data table
    put this query into a macro: mImportXL

    2nd, then the steps will be:
    1. overwrite the file, c:\temp\File2Import.xlsx, with the new data
    2. run import macro: mImportXL
    done

    the 1st query is join the xl table to your student table , join in email.
    to append data to the target table(s).

    make any more queries to add to their tables too. (if needed)

  3. #3
    saffar is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2020
    Posts
    5
    Thanks ranman256 for your reply
    Is there a vba code to attach to command button selct the file and impot the marks and append to the student record ?

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    Quote Originally Posted by saffar View Post
    Thanks ranman256 for your reply
    Is there a vba code to attach to command button selct the file and impot the marks and append to the student record ?
    Unlikely, as every scenario is different?
    Break it down and take a step at a time using Google and asking here when you cannot find it on Google (which is going to be unlikely) or you need to tweak it.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  5. #5
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  6. #6
    saffar is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2020
    Posts
    5
    sorry i don't know it is same forum
    you can delete this post

  7. #7
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    Quote Originally Posted by saffar View Post
    sorry i don't know it is same forum
    you can delete this post
    Not the same forum, but to post on other forums without advising members is considered impolite by many people, me being one of them.
    They do not want to waste their time, which they give freely, already duplicating what has been offered elsewhere.

    If you supply a link to the other threads, then they can see what has been suggested already.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  8. #8
    saffar is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2020
    Posts
    5
    Again I am sorry, and it will not happen again maybe my mistake was looking for a quick reply
    All respected member they are contributing from their own time

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

Similar Threads

  1. Replies: 6
    Last Post: 09-08-2019, 03:18 PM
  2. Replies: 9
    Last Post: 08-01-2019, 06:09 PM
  3. Replies: 2
    Last Post: 02-28-2017, 01:34 AM
  4. Replies: 10
    Last Post: 06-16-2014, 08:37 AM
  5. Replies: 2
    Last Post: 10-05-2012, 01:50 PM

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