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 |
|
aksana
Starting Member
13 Posts |
 Posted - 2008-07-21 : 21:38:11
|
Hi,everyone.Im looking for the way to import excel date to SQL Server 2005 through web application.I found "BULK INSERT", but it seems like Excel data has to be convertined to CSV file.But Excel file includes more than 1 sheet,,, up to 15 sheets. Since only one current sheet can be converted to csv file, "BULK INSERT" doesnt work for me Can anyone tell me how to import Excel data to SQL Server 2005 through web application please ??thank you.aksana |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-21 : 22:26:16
|
| Did you look at ssis package? |
 |
|
|
aksana
Starting Member
13 Posts |
Posted - 2008-07-22 : 00:21:48
|
| hi rmiao.thanks for telling me about ssis.I went this URL :http://sql-server-performance.com/articles/biz/How_to_Import_Data_From_Excel_2007_p2.aspxand It says several Excel sheets' data can be stored in DB using i/e wizard.Cell/DB column name is the same but I will import several Excel file.Such as inserting Employees' information.is it possible to change the data file to import each time through program or something?Thank you. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
aksana
Starting Member
13 Posts |
Posted - 2008-07-22 : 04:01:11
|
quote:
Originally posted by webfred
I found this link:http://technet.microsoft.com/en-us/library/ms345182.aspx(How to: Loop through Excel Files and Tables)WebfredThere are 10 types of people in the world: Those who understand binary, and those who don't...
hi webfred,thanks alot !!! and one more question.I would like to check that whether the excel data is valid or not(such as age column has to be interger,,,etc).To check data, I found this site (Get a List of Tables in an Excel File)http://msdn.microsoft.com/en-us/library/ms403358.aspx#example4Maybe I can do check through the code after getting the list of data.is there any way to do the same check? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
|
|
importing Excel into SQL server 2005 on the websit