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

cannonbow88 · #1 (**permalink**) 09-27-2006

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 · #2 (**permalink**) 09-27-2006

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.