Linked table changes cols from num to txt

  • Thread starter Thread starter Marc Miller
  • Start date Start date
M

Marc Miller

Hi All!

I have an SQL Server 2000 view to which I have linked from MS Access 2003.
The view syntax go something like this:

SELECT txtfld1, txtfld1, sum(numfld1) as abc, sum(numfld2) as def
FROM mytable
WHERE txtfld1 = 'value'
GROUP BY txtfld1, txtfld2


When MS Access links, it casts the numeric summed columns to datatype text.
Our users then copy the result set to an Excel file which in turn casts the
datatype to text.
There are about 40 summed numeric fields, so changing the Excel columns to
type number
is cumbersome and should not be necessary in the first place.

Is there a 'cure' for this?

Thank you for your time.
Marc Miller
 
Dear Marc:

I do not agree that the Access columns are going to be text, but that is not
the point.

If you import this into Excel using an already defined spreadsheet in which
the numeric columns are defined the way you want them, this will solve your
problem.

Thus, you can do this once, copying this Excel spreadsheet from the original
empty one before each import.

Tom Ellison
 
Back
Top