locked
Migrating Excel Spreadsheets to MSSQL RRS feed

  • Question

  • Hi All.

    Would you happen to know how one could convert some Excel spreadsheets to MSSQL? There is some commercially available software, but there must also be a way for me to manipulate the files.

    Many thanks!
    Nazli
    Thursday, May 17, 2007 8:21 PM

Answers

  • ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/extran9/html/667419f2-74fb-4b50-b963-9197d1368cda.htm

     

    That's where I started.

     

    Good luck

     

    ginnyK

     

    Thursday, May 17, 2007 10:20 PM

All replies

  • ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/extran9/html/667419f2-74fb-4b50-b963-9197d1368cda.htm

     

    That's where I started.

     

    Good luck

     

    ginnyK

     

    Thursday, May 17, 2007 10:20 PM
  •  What kind of conversions are you trying to do?

     Reason I'm asking is because I pull information from Excel spreadsheets all the time into SQL using packages I've built.

    Let me know what you're trying to convert.

    Friday, May 18, 2007 3:19 AM