I have a table with a definition like this:
CREATE TABLE [dbo].[SPECIAL_DAYS](
[start_date] [date] NULL,
[end_date] [date] NULL
) ON [PRIMARY]
I want to populate this table with data from an excel spreadsheet. I know how to use the SQL Server import and export wizard. My problem is with data type conversions. I have tried formatting the spreadsheet as text and as date, but there is always a conversion error and no data gets loaded. I'm using Excel 2007, and I'd like to do this using the import and export wizard. How?