April 12th, 2013, 07:15 AM
Upload Excel to Access
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 !!!!!!
April 13th, 2013, 05:39 PM
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.
Click Here to Expand Forum to Full Width