Thank u, i'm in the process now to adjust everything and see if i can make it work easier and faster that way then. NEver used indexes before, but then...
Guess the best method would be then to just import it and then use queries to join the tables together so the right information get placed into the values...
Thank u all for this information. Importing an excel i will use SSIS so far i have run a few trials and have not run into any trouble with datatypes...