| Re: How to convert Ms. Excel spreadsheet to MS. SQL? 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.
__________________ Who's afraid of the Big Black Hole?????
Go Black Hole! W the Black Hole!  
Hasta que el agujero negro nos traga, siempre!
Hypography Forum PITA...... er, Administrator.
Last edited by Qfwfq; 09-27-2006 at 04:46 AM.
|