Upload Excel to Access
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: Upload Excel to Access

  1. #1
    Join Date
    Sep 2012
    Posts
    16

    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
    Posts
    2

    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

This is a CodeGuru survey question.


Featured


HTML5 Development Center