Migrating Excel Spreadsheets to MSSQL

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

Answer 1

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

 

Answer 2

 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.