Hello everyone. I'm making a import system that i ...

# general-advice

[Marvin]

Hello everyone. I'm making a import system that i import excel sheets to the database. How can i write a method for importing big excel files to the sql server?

[Coty Saxman]

This is a pretty broad topic, with a ton of viable solutions. Here's one set of breadcrumbs that should work:

Ktor, Exposed, DataFrames, Compose (if you need a UI)

DataFrames is an official library that will handle excel file I/O
Ktor is the backend framework
Exposed is the ORM for interacting with your database

I recommend checking into those three (four if you include compose) libraries, and maybe trying a tutorial or similar. After that, you'll probably be able to answer this question, or at least ask some more specific clarifying follow-up questions.

Good luck!