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.
| Author |
Topic |
|
sross81
Posting Yak Master
228 Posts |
 Posted - 2008-05-22 : 14:32:54
|
| Hello,Is there a good way in SQL to select records that have been sent in an excel spreadsheet and import them into a temporary table?I have a list of order codes that have different seg codes for example:Order Code ZSeg7625 ZBL717009 ZBL3277 ZCI8144 ZCIEach order code is unique and is classifed into a zseq. Depending on this zseg I need to update an existing table with the following field names and values for each order code:For example for an order code classified as a ZBL I need to insert into an existing table that uses order code as the PKValue Code: PatracValue Description: Patient RaceValue Type: STUnits: NoneTemplate Name: Lab_Master_Field Name: AOE_BL_RaceThere are multiple Value codes for each Zseg that will be inserted for each order code.Can someone tell me the best way to do something like this? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-22 : 14:41:20
|
| You can use OPENROWSET function or SSIS Export/Import wizard etc. See below linkhttp://www.mssqltips.com/tip.asp?tip=1207 |
 |
|
|
|
|
|
Select Data From Excel