asked on

Import excel file into sql URGENT!!!!!!!!!

I have multiple excel file that I need to get into sql. I need the file name to be a variable passed by a stored procedure. I part I am having a problem with is how to I get it into a sql table. I know I need to create the temp table, but when I try a bulk insert the line all runs together into one column. I also need to parse out the lastname and first name when uploading. I'm really desperate to get this working today. Any help would be greatly appreicated.

The rows in my file are set up as

Name DOB Age Chart# VisitDt Provider Office Diag1 CPT SSAN Sex Address City State Zip Rating
Test,Justine 13-May-61 44 s1234 10-Jan-06 d59 mfc 296.7 99211 512-41-4444 m 123 Test Street Test City CO 12457 z

SjoerdVerweij

How do you do the bulk insert? How do you store the Excel file? What are your seperators?

running32

ASKER

I am storing the excel file on the sql server.

The csv is comma delimited.

I thought I could do the bulk insert as but it all runs into one column.

drop table [HealthDistrict].[dbo].temp2

CREATE TABLE [HealthDistrict].[dbo].[Temp2] (
[strName] nvarchar (255) NULL,
[dtmdob] smalldatetime NULL,
[lngage] float NULL,
[strchart] nvarchar (255) NULL,
[dtmvisit] smalldatetime NULL,
[strprovider] nvarchar (255) NULL,
[stroffice] nvarchar (255) NULL,
[strDiag] nvarchar (255) NULL,
[strcpt] nvarchar (255) NULL,
[strssnum] nvarchar (255) NULL,
[strsex] nvarchar (255) NULL,
[straddress] nvarchar (255) NULL,
[strcity] nvarchar (255) NULL,
[strState] nvarchar (255) NULL,
[strzip] nvarchar (255) NULL,
[strrating] nvarchar (255) NULL
)
ON [PRIMARY]
GO
BULK INSERT temp FROM 'd:\download\2006.csv' WITH (FIELDTERMINATOR = ',', FIRSTROW=2)

ASKER CERTIFIED SOLUTION

Ved Prakash Agrawal

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION