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 |
|
JJins
Yak Posting Veteran
81 Posts |
 Posted - 2010-10-20 : 10:59:53
|
| I have an excel document saved normaly as AL.Chart.Rates. The file has three tabs, A, B, C. Then I have a database called Rating_2 with tables titled dbo.RatesA ,dbo.RatesB, and dbo.RatesC. How do I run a query that will insert the data from each tab into each table. Thanks,GG |
|
|
JJins
Yak Posting Veteran
81 Posts |
Posted - 2010-10-20 : 11:18:47
|
| Another issue is that I do not want to bring rows 1, 2 and 3 from excel into my table because those rows are just titles/headers. Thanks for the help.GG |
 |
|
|
JJins
Yak Posting Veteran
81 Posts |
Posted - 2010-10-20 : 14:07:18
|
| NO help? |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2010-10-20 : 16:04:16
|
| Name the ranges in Excel you want to import(excluding Headers) RatesA,RatesB and RatesC. Then use import/export wizard to import those ranges from Excel into SQL.JimEveryday I learn something that somebody else already knew |
|
|
|
JJins
Yak Posting Veteran
81 Posts |
Posted - 2010-10-20 : 16:37:06
|
| I want to insert from excel rows 4 - 749 (above 4 is headers) and columns A-H. and do this for tabs A,B,C. There are already tables rateA, RateB, RateC that have filed names sitting empty. Does that help at all in figureing out how write the query.Best,Graham |
|
|
|
|
|
|
|
|
Inserting excel doc tabs