[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