ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   sequel into excel problem (https://www.excelbanter.com/excel-programming/427015-sequel-into-excel-problem.html)

Pammy

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