automate importing text via macro and windows scheduler issue

  • Thread starter Thread starter Alexander Heimann
  • Start date Start date
A

Alexander Heimann

I have succesfully created a macro to update a table by importing a
text file using the transfer text macro and the import specification.
When I click on the macro i get a text pop up letting me know it
couldn't append all the records in the text file due to key
violations. This is fine because i just need to update new records so
i click yes and continue anyway and it works great.. My problem is
that i want ot automate this macro using windows scheduler. I won't
able to click yes obviously. Any ideas? Should I Code a macro that
handles the pop up. Do you think I should import the text file into a
temp table, use a query to find new records, then only import new
records.

What do you guys think?

A
 
Alexander,

Put a SetWarnings/No action in your macro ahead of the TransferText action.
 
Steve Schapel said:
Alexander,

Put a SetWarnings/No action in your macro ahead of the TransferText action.
Click to expand...

thanks for all your help guys. now if the sys admin will get back to
me i can set up the scheduler. that database is on a networked drive
and i am thinking the reason the macro's aren't running is because i
need to set the scheduler on the server and not on my workstation,
probably a goodidea either way .. that way i can turn my workstation
off

thanks again
 
Back
Top