Macro doesn't replace an existing file. It did in Access 97.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro that performs several functions. It runs six queries, the
last one creating a table. I then have the macro setup to export that table
to an AS400 location. This is where it fails. It halts the macro and gives
me an message box that tells me the table "payrolje.csv" already exists. Has
an OK and help button. If I press OK, the macro is still halted. What do I
have to do so that this function continues?
 
Dlheim,

I assume you are using a TransferText action in your macro to export the
data to the payrolje.csv file? As far as I know, this problem can not
be overcome with a macro. The existing payrolje.csv file will need to
be deleted first, and for this you will need to use a VBA procedure
using the Kill method.
 
Back
Top