Last post Feb 13, 2015 06:32 AM by vijaypant
Feb 10, 2015 03:09 PM|Chris17|LINK
I am building an application that needs to use excel to upload a lot of data to the SQL Server.
I have been able to write the codes for the uploads and it went well.
What I need to do now is: In each table I am uploading to, there is a relationship to another table and I need to create a dropdown that would read the foreign key table data and preview the values but submit the keys.
For Instance, If I had a table
Student No ------ Name ---- Date of Birth -------- DepatmentID
I need the Department Id to be a dropdown in excel which all the departments shown are read from my SQL Server Department table and then the Department Name are previewd but only the PK are submitted during upload.
Any Ideas to go about this?
Thanks and Regards
Feb 13, 2015 06:32 AM|vijaypant|LINK
Hi if you want that dropdown inside the excel file itself then use VBA to achieve the same.