2
votes
2answers
69 views

Is there a better way than the ones listed within to join data in an excel spreadsheet to a table in a SQL Server database?

Let's say I'm given a list of names and email addresses in an excel spreadsheet. I am asked to find all customers in the database who's name, and email are in that list. I currently know of two ways ...
1
vote
0answers
257 views

Update excel sheets from SQL Server 2005 linked servers

I use SQL Server linked servers to connect to Excel 2003 multiple tabs workbook. After connected, I have not problem to use select statement like: select * FROM OPENQUERY(TEST, 'select * from [fist ...
1
vote
1answer
1k views

OPENROWSET can't import an excel spreadsheet into SQL Server 2005 Express

I am trying to run the following query to select data from an excel spreadsheet: SELECT FT_ID_SOCIETE_FF2C,FT_NOM,FT_ADR1,FT_ADR2,FT_ADR3,FT_CP,FT_VILLE,FT_TEL,FT_FAX,F10 FROM OPENROWSET ...