Post reply

Import from Excel? Maybe DTS in SQL Server CE?

  • May 12, 2009 at 7:54 am

    #384566

    I need to figure out a way to use an Excel file to determine the data structure and data for a SQL CE Database. Ideally, I'd be able to just suck it all at one time becuase building the table and iterating through the Excel one row at a time is painfully slow. I'd heard SQL Server CE had data transformation services. Is that true? If so, could I use it to do this? If not, how can I do this? Thanks!

  • May 29, 2009 at 7:39 am

    #1002047

    Hi ,

    You jut need to rightclick the database , then select the Export option, it will open up the export wizard, there you need to specify the source(in your case it will be the OLDB Soruce ) click next then give the destination (Excel Destination ), lick next and now select the table you need to export to the excel.

    Once you done with the above steps and click the OK button the export to Excel will takes place.

    Here actualy in the Back ground it is doing with the DTS(Data Transfer Services)

    Hopes this will help you.

    Regards,

    MC

    Thanks & Regards,
    MC

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply