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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-09-12 : 18:32:46
|
| sabegh writes "Hello all:I have gone through most of the question posed by people, about importing data from EXCEL sheet to some table using SQL server database. I have a slight variation of this problem.My excel file contains some information apart from the normal data.Lets say some 5-6 lines always gives me some info about the data, like its purpose, client info, date etc...After this INFO my actually data start, which I want to load into table.I have found some wizard for the same, "EMS SQL MANAGER 2005", which supports most of the file formats, and load data into the database.But we are planning to not use this tool, instead everything should be done using TSQL.If somebody can please gives me some idea how this problem can be tackle, it would be a great help. We won't be using any Third party tools, like scripting etc...We want to stick with just TSQL for this problem.Thanks a bunch,sabegh" |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-12 : 19:55:34
|
| I would investigate a Linked Server option. This effectively links the Excel file and presents it as a table or tables for you to query via TSQL.Check out Linked Servers in BOL.Or you could always challenge whoever issued that directive...... |
 |
|
|
|
|
|
Importing data from Excel