P
Pammy
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?
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?