Importing Access queries into Excel

C

Crystal

I'm trying to import a totals query from Access into
Excel. When I do, I get "Invalid character value for cast
specification on column number 2(Total)"

I only get this error when I use the Sum and GroupBy
functions in an Access query.

Is it possible to link an Access totals query to an Excel
spreadsheet.

Any help would be greatly appreciated,
Crystal
 
C

Chule Walker

In MS Query (the program Excel used to query external
data) the Totals function seems to work slightly different
than in Access. I would remove the Totals function in the
Access query and add it in MS Query by selecting the
column and clicking on the Cycle Through Totals button.
My problem is that I can't seem to use parameters in
conjunction with the Totals function (Max). Hope this
helps!

Chule Walker
[email protected]
 
Top