ExcelBanter
(
https://www.excelbanter.com/
)
-
Excel Programming
(
https://www.excelbanter.com/excel-programming/
)
- -
sequel into excel problem
(
https://www.excelbanter.com/excel-programming/427009-re-sequel-into-excel-problem.html
)
Nigel[_2_]
sequel into excel problem
Seeing the code might help diagnose the problem?
--
Regards,
Nigel
"Pammy" wrote in message
...
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:40 PM
.
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com
