CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2012

    Upload Excel to Access

    For Example:

    I have database in Access with Table Student (StudentID, StudentName, Address,Telephone).
    And Excel file is missing StudentID.
    Excel is including :StudentName,Address,Telephone.

    Now I want to write the program to check the Excel file is upload to Database Access if the column in Excel file is missing (StudentID) and the Database Access is known as StudentID = 0.

    I appreciate for your help !!!!!!

  2. #2
    Join Date
    Apr 2013

    Re: Upload Excel to Access

    You may not be able to do this, because StudentID is probably a key field. If so, you can't have duplicates. If it isn't a key field, you probably need one.

Posting Permissions

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

Windows Mobile Development Center

Click Here to Expand Forum to Full Width

On-Demand Webinars (sponsored)

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.