F
Florian
Hi!
I have created a DTS which runs every midnight on my customers server
to transfer some excel data to a ms sql database.
The problem is, if somebody at my customers office forgets to close
the excel file the import will fail because it's in use by excel.
Can I somehow override this file locking problem or Can I find out
wether a file is in use or not. I tried to create a small VB script
which opens the excel file. There it works and I don't get a error
message cause it's opened elsewhere.
Is there any VB function which can help me out? I tried to find a VB
script reference for DTS - but without a result.
greetings,
florian
I have created a DTS which runs every midnight on my customers server
to transfer some excel data to a ms sql database.
The problem is, if somebody at my customers office forgets to close
the excel file the import will fail because it's in use by excel.
Can I somehow override this file locking problem or Can I find out
wether a file is in use or not. I tried to create a small VB script
which opens the excel file. There it works and I don't get a error
message cause it's opened elsewhere.
Is there any VB function which can help me out? I tried to find a VB
script reference for DTS - but without a result.
greetings,
florian