Possible to Import Access queries to Excel and maintain the formulas??

F

fred.sheriff

Hello: I am trying to confirm whether it is possible to import access
queries intto Excel and keep the formulas so that they will still
exist in Excel.

Is that possible to do?

Thanks!
 
S

strive4peace

Hi Fred,

not without writing code -- and, depending on your calculations, this
may be very difficult

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
J

John W. Vinson

Hello: I am trying to confirm whether it is possible to import access
queries intto Excel and keep the formulas so that they will still
exist in Excel.

Is that possible to do?

Thanks!
Click to expand...

Not directly. What you can import or export from an Access Query is the
*values* of the expressions - not the expressions themselves. A Query is NOT a
spreadsheet, and does not contain any expressions, other than in its SQL text
(which Excel can read only in the sense that it can run the query against an
Access table).

John W. Vinson [MVP]
 
D

Dave K

Thanks for the replies! Very much appreciated.

Not directly. What you can import or export from an Access Query is the
*values* of the expressions - not the expressions themselves. A Query is NOT a
spreadsheet, and does not contain any expressions, other than in its SQL text
(which Excel can read only in the sense that it can run the query against an
Access table).

John W. Vinson [MVP]
Click to expand...
 
Top