• Back to Job Interview Question listing

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

Answer

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.

Related Quality Assurance (QA) job interview questions