H
Heiko
Hi,
I'm trying to export dates from a query to excel in a
first step, let excel do some calculations, and import the
results back to a table in Access in a second step for
further queries. Unfortunately, excel doesn't recalculate
the fields when I export new dates. When opening the excel
file always after the first step, and closing it
immediately, everything is working. But I need to automate
this process.
Is there maybe even another way to communicate between
Access and Excel? Thanks!
I'm trying to export dates from a query to excel in a
first step, let excel do some calculations, and import the
results back to a table in Access in a second step for
further queries. Unfortunately, excel doesn't recalculate
the fields when I export new dates. When opening the excel
file always after the first step, and closing it
immediately, everything is working. But I need to automate
this process.
Is there maybe even another way to communicate between
Access and Excel? Thanks!