How to convert Ms. Excel spreadsheet to MS. SQL?

[cannonbow88]

hello.. the Hypography Members.. I have a problem of how to convert from Ms. Excel spreadsheet to MS. SQL. Last times, i learn before but can't remember how. I remember that i need to change the Ms. Excel file to CSV. file. After that, how am i going to call it to MS. SQL. Help is appreciate!

[Qfwfq]

Have you tried Embarcadero DBArtisan? Another way is to write a program that uses Excel via Automation and executes inserts via ADO. Perhaps MS SQLServer also has a fuction for reading in CSV but it would depend on how the data is in Excel, which isn't really an RDBMS.

[alexander]

http://www.surfpack.com/downloads/Excel-to-MSSQL/30003.html

that is an excell to mssql converter

 

and if you needed mysql, then here is an mssql mysql converter

http://www.surfpack.com/downloads/MSSQL-lt-gt-MySQL-Converter/29446.html

enjoy :)