Format problem

B

Bob McClellan

Hello,
I am updating a spreadsheet as a linked table
from an SQL Stored procedure. No matter how I send
in the data, and no matter how I try to force the format of the
cells.... it continues to show as text. all values have the 'to the left
of the number, rendering them as text.

Is there a way to combat this...?
Everything works, the data all goes where it is supposed to go...
I just want it to be numeric... NOT text

...this is the create table sql
exec spExecute_ADODB_SQL
@DDL='Create table ExecUtilHistoryDetailed
( id int
, Header char(20)
, cccID int
, ClassDesc Char(50)
, d1 DECIMAL(9,2)
, d2 DECIMAL(9,2)
, d3 DECIMAL(9,2)
, d4 DECIMAL(9,2)
, d5 DECIMAL(9,2)
, d6 DECIMAL(9,2)
, d7 DECIMAL(9,2)
, d8 DECIMAL(9,2)
, d9 DECIMAL(9,2)
, d10 DECIMAL(9,2)
)'
, @DataSource
='C:\Mail.Files\Utilization\Utilization.Executive.Summary.V3.xls'

thanks.
bob.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top