Likely a less complicated solution exists. But not without some reading up on the subject wrt Excel ...
You could however just "save" your spreadsheet as a text file with .txt extention making sure it's "td" (tab-delimited). Something like this will result:
001 Stars&StripesForever sousa@phoneydata.com yes 2005-05-02 11:59:00.001
002 AintNoWomanLiketheOneIGot peaches@twentysixteen.com yes 2005-12-14 11:59:02.110
003 100101011100111100000011 ss@nautpott.com no 2013-02-07 07:77:59.077
In SQL2005 Studio Management application, create a new .sql "query" by clicking on "Create New Query" button
Copy this code:
USE [cpqaAnswer]
GO
CREATE SCHEMA [cpqa]
CREATE TABLE [cpqaAnswer].[cpqa].[tblExcelTdData](
[idx][int],
[title][nvarchar](128),
[email][nvarchar](256)
[status][nvarchar](16),
[time][datetime]
)
BULK INSERT [cpqaAnswer].[cpqa].[tblExcelTdDate] FROM 'C:\users\pn\datafile(td).txt'
Paste it in the editor, then type in a new SELECT clause to see the tabled data:
SELECT * FROM [cpqaAnswer].[cpqa].[tblExcelTdData]
Submit an article or tip