I am using an export module in our accounting package to export 4 fields into an access table. I had to create my very first ODBC data source. I works ok. The problem I am having is that every time I export the fields it appends to the table and creates duplicates, triplicates and so on.
Is there a way that I can delete all rows when the file is opened for writing, not reading. This simple db will be queried on many times throughout the day.
Thanks for any advice you can give
Is there a way that I can delete all rows when the file is opened for writing, not reading. This simple db will be queried on many times throughout the day.
Thanks for any advice you can give
