save a large dataset

I am trying to load a large data set into SQL sever. It is with 5 million records.

I find loading data into SQL sever is extremely slow with Output Tool. Loading data into a Excel sheet is much faster. But excel cannot hold so much records.

Is there any good way to do it except split the data?

Thank you.

Datasets

Database Connection

Accepted answers

CharlieS

How is your connection to the database configured? Try using the SQL Server Bulk Connection.

All comments

CharlieS

How is your connection to the database configured? Try using the SQL Server Bulk Connection.

Amy18

Hi @CharlieS

Can you show me how to use the function? I got an error. Did I do anything wrong? Thanks.

After typing in the user name and password, I gave the name of my table to create. In the end, I still got below error.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703