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 - 2005-10-21 : 07:53:39
|
| Chris writes "I am creating a DTS package that is writing the results of an Access query into an existing Excel Spreadsheet. I am allowing the DTS package to created the spreadsheet in an existing Workbook. The problem is that DTS is putting a leading single quotes into the values and column headers when it executes. I am using an Active Script task on completion to move the data values into fields on another spreadsheet that has formulas and they are not working because of the leading quotes. Help!" |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-10-21 : 08:31:34
|
Why aren't you using Access's export to spreadsheet option?Corey Co-worker on children "...when I have children, I'm going to beat them. Not because their bad, but becuase I think it would be fun ..."  |
 |
|
|
crbrooks58
Starting Member
1 Post |
Posted - 2005-10-24 : 08:25:14
|
| The reason I am using Access is that I am running a Cross Tab query which Microsoft only has available in Access. I have been working with the results and it does not appear to be a valid single quote that it is putting in the fields. You can not run a find and replace because it says the quote is not there. When you look at the results in the grid there does not appear to be a quote. But when you select it in the formula\value window you see the apparent quote. Very strange behaviorI am going to live forever...or die trying! |
|
|
|
|
|
|
DTS from Access DB to an Excel Spreadsheet.