Importing Data from Excel file to SQL Compact Edition Database

• Jenson-458469

  SSC Veteran

  Points: 253

  More actions

  June 29, 2007 at 1:53 am

  #175122

  Hi Guys,

  I'm trying ways to import data from excel file into SDF database (SQL 2005 Compact Edition) and insert the data into respective table and column.

  Any idea how should I achieve that? Has any of you done that before? Would appreciate any kind of helps offered.

  Thanks.

  Regards,

  Jenson

• Charlie-120533

  SSCrazy

  Points: 2187

  More actions

  October 22, 2007 at 1:07 pm

  #744222

  See my reply here:

  http://www.sqlservercentral.com/Forums/Topic376763-323-1.aspx

  It helps to be a programmer.

• Charlie-120533

  SSCrazy

  Points: 2187

  More actions

  October 23, 2007 at 7:54 am

  #744542

  I found a way to copy a spreadsheet into 2005 Express by using the DTS Wizard. It's located in:

  Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard

  It's pretty straight-forward. I need to figure out how to access it through the SQL Server Management Studio page. It's a learning experience since we still can not use it at work. I assume the full-blown SQL 2005 Enterprise has everything set up for you. But, for now, this will work for my imports.

• ms44cn

  SSC Journeyman

  Points: 94

  More actions

  May 25, 2008 at 9:51 pm

  #820096

  This utiltiy can do this task .

  It support import data from excel to sqlce .

  But the UI is WPF , so you need install .net 3.5

  https://sourceforge.net/projects/sqlceviewer