Showing posts with label SQL Server Import Excel. Show all posts
Showing posts with label SQL Server Import Excel. Show all posts
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

 
Related Posts Plugin for WordPress, Blogger...