Importing Access queries into Excel

  • Thread starter Thread starter Crystal
  • Start date Start date
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
 
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
(e-mail address removed)
 
Back
Top