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

[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!

 

[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
*

 

[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!

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]

 

[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]