I
I
iluxa18102016-10-01 13:50:20
.NET
iluxa1810, 2016-10-01 13:50:20

How to import from MS SQL Server into Access via C#?

How to quickly import tables into Access from MS SQL via C#?
It is possible to read single rows from MS SQL tables through DataReader and insert them into Access with single INSERTs, but this is a long time, in my opinion.
Is there anything faster?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
R
Roman, 2016-10-02
@yarosroman

Make a query "insert into OPENROWSET (provider, connection string, table query) Select ..."

R
Roman Sokolov, 2016-10-10
@jimquery

Boot into the console, read the logs and fix it. Killed the system with a dist-upgrade update.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question