Complete Guide to Microsoft Access AI Integration.
Complete Guide to Microsoft Access AI Integration. Contents: Installing Ollama, Installing the Qwen model, Connecting VBA to AI, Building JSON Request, Prompt Engineering, SQL Generation, VBA Generation, Debugging AI Output, Explain SQL, Explain VBA Code.
Contents:
- Installing Ollama
- Installing the Qwen model
- Connecting VBA to AI
- Building JSON Request
- Prompt Engineering
- SQL Generation
- VBA Generation
- Debugging AI Output
- Explain SQL
- Explain VBA Code
First of all, I'd like to thank you very much for this article. It was the most practical and helpful of all the articles and videos I've found so far on integrating Access with artificial intelligence.
ReplyDeleteIn fact, I followed the steps outlined in the article, and the experiment was successful, but I noticed just one issue—and I believe it stems from the code that generates the JSON.
When I receive the response, the number 1 appears before every double quote.
This can be seen in the first entry in the example you attached , where the result was as follows:
Set rs = db.OpenRecordset(1"Customers1", dbOpenDynaset)
Notice how the number 1 precedes every double quote.
I’ve reviewed the code and noticed that when I modified the command
extResp = Replace(extResp, "\", vbNull)
to
extResp = Replace(extResp, "\", vbNullString)
this was the result:
Set rs = db.OpenRecordset("SELECT CustomerName FROM Customers")
So, is this change correct, or will it cause a problem?
Translated by Google