June 29, 2007 at 1:53 am
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
October 22, 2007 at 1:07 pm
See my reply here:
http://www.sqlservercentral.com/Forums/Topic376763-323-1.aspx
It helps to be a programmer.
October 23, 2007 at 7:54 am
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.
May 25, 2008 at 9:51 pm
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply