Need help exporting Excel to SQL 2005 table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Need help exporting Excel to SQL 2005 table

Author

Topic

iitt2007
Starting Member

1 Post

Posted - 2008-04-23 : 15:53:10

Scenario :
SQL table has 2 columns SQ1, SQ2
Excel sheet has three columns : EX1, EX2, EX3

SQ1 matches with EX2
SQ2 matches with EX3

I would like to insert the rows where EX1='X'. EX1 is the left most column in th Excel sheet.

Here's what I am trying. Could you suggest any changes/suggestions?

-- Link server logic
IF EXISTS (SELECT srv.name FROM sys.servers srv WHERE srv.server_id != 0 AND srv.name = N'Config_spreadsheet_load')EXEC master.dbo.sp_dropserver @server=N'Config_spreadsheet_load', @droplogins='droplogins'
GO

--This is the link logic to connect the spreadsheet to the database
sys.sp_addlinkedserver 'Config_spreadsheet_load',
Excel',
'Microsoft.Jet.OLEDB.4.0',
In : @ExcelfileName,
'excel 8.0;
IMEX=1;
GO

-- Insert Plan Codes, for the column (PLC_NEW_COL) marked as ‘X’
insert into Plan_code (SQ1,
SQ2)
-- **** How can I have the logic for checking EX1='X'
where PLC_NEW_COL like ‘X’
-- Once the data has been created, clean-up

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-04-23 : 17:54:19

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources