Export to SSIS and maintain Drop down

  • Hello All,

    In this i have two task to be done. I have to export data from a excel 2007 to Table in sql server 2008. the excel has drop down list where user has selected the values. this export to table can be achieved with out any problem.

    But the same vice versa like from table to excel 2007 where i need to maintain the same drop down options in the excel. Can you please guide me on this. thanks.

  • Please post answers here:

    http://www.sqlservercentral.com/Forums/Topic1224879-364-1.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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