Advice

I use SQL to read data from a closed workbook. Is it possible to write new records or updates to a record in a closed workbook using SQL?

Improve this question

2 Replies 2

Tim Williams
•

Yes it's possible - for example see this post Write/update data via ADO to closed Excel workbook Whether it will work for your particular use case may depend on the details of what you want to do.

Improve this answer
Karl-Heinz
•

That's perfect. Thank you very much for your support. The tests show that it works.

Improve this answer

Your Reply

By clicking “Post Your Reply”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.