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 |
|
CLages
Posting Yak Master
116 Posts |
 Posted - 2006-04-06 : 09:09:11
|
| Hi, i am using this query to export to Excell , works fineexport my table starting at A1 columnm but If i run twice the second time start at A32 Column (my table has 31 rows)the question is: How can i clear the Excell Spreadshett first to alwaysstart at A1 column?tksC. Lages insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\LIXO\testing.xls;HDR=YES','SELECT * FROM [Plan1$]') select * from AREA |
|
|
|
|
|
Exporting to excell (how to clear Excell first)