Conditionally Export Access Table to Excel

Question

Is it possible to automate the conditional export of an Access table to Excel if it meets specific criteria? I would like to export a final Access table to Excel only if the Updates field value is >10 after I run my macro. Otherwise, I do not want the table to be exported from Access to Excel.

Answer 1

In which row in the table should the value at the Updates column position be >10?  Or are the Updates values in every row in the table the same?  If the latter then the table should be decomposed, with the Updates value being in a single row in a referenced table.  This removes the risk of update anomalies.

Either way you will probably need to call the DLookup function to get the value.  Do this in an If….End If construct, in which the export to Excel is conditional on the return value of the function being >10.

To export a table to Excel in VBA the TransferSpreadsheet method of the DoCmd object is used.

Answer 2

Yes, this is possible. How? Ah, the details derived from a high-level overview....

It might involve a conditional similar to this:

If tblYourTableNameGoesHere.Updates >10 THEN

  ...Code to export the table to Excel

End If

Put those lines in the procedure after the other code runs. I see you mention a macro, which I'd recommend you convert to VBA for this, and other purposes, anyway. Macros are fine for simplistic processes, but more serious work requires the greater power and flexibility of VBA.