Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server
I've got an excel file with more than 30,000 record and I want to convert it to sql server file how can I do that please help
thanx all
Posted 13-Oct-12 9:34am
Comments
haitrieu749 at 13-Oct-12 15:46pm
   
Data's very large :D
Khaldoon Al-Talib at 13-Oct-12 15:53pm
   
not so large it is just 30,000 record
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Comments
Khaldoon Al-Talib at 13-Oct-12 16:16pm
   
I need a program not a code to do that
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

You can not convert an excel file to sql server file.
But if you can figure out a structure where your rows will fit in, you can import the excel file with the import wizard in SQL Management Studio[^]. See a guide: http://www.66pacific.com/sql_server_import_from_excel.aspx[^].
Be aware, that excel worksheets are not tables, they are sort of free-form. A relational table needs to have a structure, thus not all excel worksheets can be imported directly.
  Permalink  
Comments
Khaldoon Al-Talib at 13-Oct-12 19:18pm
   
it is exactly what I need

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 434
1 Maciej Los 155
2 Richard MacCutchan 130
3 DamithSL 129
4 Kornfeld Eliyahu Peter 119


Advertise | Privacy | Mobile
Web01 | 2.8.140709.1 | Last Updated 13 Oct 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid