StumbleUpon
Share on Facebook

Monday, September 10, 2012

How to import CSV / Excel file to SQL Server Table

How to Load Excel File / CSV File to a SQL Server Table / Create SQL Server Table from Excel File

Step 1: Select Import and Export Wizard from Program


Step 2: Select Import and Export Wizard from Program

 Step 3: Select Flat File as Source


Step 4: Select the CSV / Text file

Step 5: Choose the Server


Step 6: Choose Database


Step 7: Specify Schema and Table Names
 Step 8: Run the Pachage

 

No comments:

Related Posts Plugin for WordPress, Blogger...