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 |
|
getsaby
Starting Member
11 Posts |
 Posted - 2006-08-23 : 16:20:53
|
| 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 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-08-23 : 18:02:15
|
| This forum is not for questions, it is for posting working scripts.CODO ERGO SUM |
 |
|
|
|
|
|
Importing data from Excel to SQL SERVER database