How to Create SQL Tables using Excel Sheets as the basis for data.....?
Posted on 2007-12-03
I use the FREE version of SQL Server 2005. It's call MS SQL Server Management Studio EXPRESS.
Does this version allow me to use Excel Sheets to IMPORT data into data TABLES in SQL Server...?
Currently,...I use Crystal Reports to "extract" the data from the Excel Sheets then I use Crystal's EXPORTING program to export the data into a SQL TABLE. Can the SQL Server EXPRESS edition do this instead of my having to use Crystal Reports?
And if so,.....HOW ....do I do it....?