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