![]() |
sequel into excel problem
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? |
All times are GMT +1. The time now is 05:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com