Products
Services
Contact Us

Scripts: C# :: File to sql server import :: Library Article #18

Developer's Section

Import Large Files to SQL Server
By: Erobo Team Member

Hire a Developer for Related Work / Installation | $55 hr
Rating:  | Rate It:   
Average Votes: (1123)
Favorites:

Learn a technique to import large files (500k - 900k rows) into a SQL Server Instance

If you are having a hard time bringing large amounts of data from an Excel file, CSV file, or Text file into a SQL server instance, or you simply want a tool to automatically bring your files with the ease of a few clicks, you can try the File To SQL Server data tool. This is the idea tool to use when you have to do lots of data transfers or need to move extremely large amounts of data into a sql server data table.

In this case once you download the tool from the online store you can proceed to do the following steps:

1. Setup the connection source to your sql server instance and the connection source to your file:



2. Choose the data transfer options:



3. Transfer the data:



And that's it, hope you enjoy!


See other Scripts in File to sql server import

Submit Your Scripts:


System Message:
  • Your C# script has been sent. Please allow 48 hours for processing.


If you would like to have your Javascripts published in this section please fill out
the form below:
*Your Name or Username:
Home Town:
*Email:
*Description and Code:
*Enter Code shown
to the right:

[ Refresh Image ]