You have an Excel sheet with 300 000 customers (columns CustomerId, Name, Phone). How would you transfer the data to the database server?

Answers

• Use out-of-the-box import utility
• Write formula that will compose INSERT INTO statements, run the query
• Use some programming language that will load the data from Excel and sends them to the database server - details how this would be done are highly appreciated.