[dba-Tech] Exporting Formulas from Table to Spreadsheet

Rocky Smolin rockysmolin2 at gmail.com
Wed Sep 11 12:29:19 CDT 2024


Dear List(s):

I have created a table in Access which needs to be exported to a
spreadsheet. It works well except for two cells which contain formulas.
When a field containing for example =F2-D2 is exported it comes out in the
spreadsheet as text.

Is there a way to format this field inthe table so that when using
TransferSpreadsheet excel will recognize this as a formula instead of text?

MTIA

Rocky


More information about the dba-Tech mailing list