Quote Originally Posted by arnelgp View Post
maybe export first your table to a csv and then
create a script in MSSQL server to import the data from the csv file:
BULK INSERT YourTableNameFROM 'C:\YourFilePath\YourFile.csv'
WITH
(
    FIELDTERMINATOR = ',',  -- Specify the field terminator (comma in this case)
    ROWTERMINATOR = '\n',    -- Specify the row terminator (newline character)
    FIRSTROW = 2,            -- Specify the first row to import (if needed)
    DATAFILETYPE = 'char',   -- Specify the type of data in the file
    TABLOCK                -- Acquire a table-level lock
)
Are you able to provide a BULK INSERT example that is based on a txt file?