USE [weather]
GO

/****** Object:  Table [dbo].[weatherimport]    Script Date: 29/05/2016 07:41:10 ******/
DROP TABLE [dbo].[weathermonthlyimport]
GO

/****** Object:  Table [dbo].[weatherimport]    Script Date: 29/05/2016 07:39:35 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[weathermonthlyimport](
	[snapdate] [varchar](10) NOT NULL,
	[snaptime] [varchar](10) NOT NULL,
	[temp] [decimal](18, 2) NULL,
	[rh] [decimal](18, 2) NULL,
	[dewpoint] [decimal](18, 2) NULL,
	[windspd] [decimal](18, 2) NULL,
	[windgust] [decimal](18, 2) NULL,
	[winddir] [decimal](18, 2) NULL,
	[rain] [decimal](18, 2) NULL,
	[totrain] [decimal](18, 2) NULL,
	[pressure] [decimal](18, 2) NULL,
	[cumrain] [decimal](18, 2) NULL,
	[roomtemp] [decimal](18, 2) NULL,
	[roomrh] [decimal](18, 2) NULL,
	[lategust] [decimal](18, 2) NULL,
	[windchill] [decimal](18, 2) NULL,
	[heatind] [decimal](18, 2) NULL,
	[uv] [decimal](18, 2) NULL,
	[solrad] [decimal](18, 2) NULL,
	[transp] [decimal](18, 2) NULL,
	[anntransp] [decimal](18, 2) NULL,
	[apparenttemp] [decimal](18, 2) NULL,
	[maxsolrad] [decimal](18, 2) NULL,
	[sunhours] [decimal](18, 2) NULL,
	[windbear] [decimal](18, 2) NULL,
	[raintoday] [decimal](18, 2) NULL,
	[rainsince00] [decimal](18, 2) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

BULK
INSERT weathermonthlyimport	
FROM 'D:\Cumulus\data\sep18log.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO

