I have a text file converted into a sequel table, this takes and runs the
data into the correct columns and then exports to an excel workbook. I plan
to automate this to run. The problem I have is when it runs it puts it at
the end of the data that imported from last month. If I delete the rows from
the workbook before I run the sequel table, it still acts as though there is
data in there and goes to the end so I have blank rows above. If I delete
the workbook and run the sequel table it says it cannot find the workbook.
I want the old data to delete and then add the new data. Any idea on what is
going on?