Access is good for smaller data sets and it provides a better way to store data then just dumping it all into an excel file, and it provides an easy to use interface which has full access to VBA so it can be interoperable with all office365 applications. And it can act as a frontend to bigger databases like MySQL, SQL Server, PostgresSQL etc
Dear Alex , what`s wrong with this code i am using powershell command to read text from image.. i have already installed tesseract 5.0 version and also added the path to environment variable.. Sub ReadTextUsingShell() Dim myshell As Shell32.Shell Set myshell = New Shell32.Shell Dim argu As String Dim ImagetoReadPth, output As String ImagetoReadPth = "C:\Users\Sunil Kumar\OneDrive\Desktop\File\ImgtoRead.jpg" output = "C:\Users\Sunil Kumar\OneDrive\Desktop\File\1.txt" argu = "tesseract.exe " & ImagetoReadPth & " " & output & " -l eng" myshell.ShellExecute "powershell", vArgs:=argu End Sub Powershell window pops-up but do nothing and get closed..
Dear Alex , what`s wrong with this code i am using powershell command to read text from image.. i have already installed tesseract 5.0 version and also added the path to environment variable.. Sub ReadTextUsingShell() Dim myshell As Shell32.Shell Set myshell = New Shell32.Shell Dim argu As String Dim ImagetoReadPth, output As String ImagetoReadPth = "C:\Users\Sunil Kumar\OneDrive\Desktop\File\ImgtoRead.jpg" output = "C:\Users\Sunil Kumar\OneDrive\Desktop\File\1.txt" argu = "tesseract.exe " & ImagetoReadPth & " " & output & " -l eng" myshell.ShellExecute "powershell", vArgs:=argu End Sub Powershell window pops-up but do nothing and get closed..
Good lessons
Why not using SQL Server instead of Access?
Access is good for smaller data sets and it provides a better way to store data then just dumping it all into an excel file, and it provides an easy to use interface which has full access to VBA so it can be interoperable with all office365 applications. And it can act as a frontend to bigger databases like MySQL, SQL Server, PostgresSQL etc
Dear Alex ,
what`s wrong with this code i am using powershell command to read text from image.. i have already installed tesseract 5.0 version and also added the path to environment variable..
Sub ReadTextUsingShell()
Dim myshell As Shell32.Shell
Set myshell = New Shell32.Shell
Dim argu As String
Dim ImagetoReadPth, output As String
ImagetoReadPth = "C:\Users\Sunil Kumar\OneDrive\Desktop\File\ImgtoRead.jpg"
output = "C:\Users\Sunil Kumar\OneDrive\Desktop\File\1.txt"
argu = "tesseract.exe " & ImagetoReadPth & " " & output & " -l eng"
myshell.ShellExecute "powershell", vArgs:=argu
End Sub
Powershell window pops-up but do nothing and get closed..
Dear Alex,
Kindly help on my below query
Dear Alex ,
what`s wrong with this code i am using powershell command to read text from image.. i have already installed tesseract 5.0 version and also added the path to environment variable..
Sub ReadTextUsingShell()
Dim myshell As Shell32.Shell
Set myshell = New Shell32.Shell
Dim argu As String
Dim ImagetoReadPth, output As String
ImagetoReadPth = "C:\Users\Sunil Kumar\OneDrive\Desktop\File\ImgtoRead.jpg"
output = "C:\Users\Sunil Kumar\OneDrive\Desktop\File\1.txt"
argu = "tesseract.exe " & ImagetoReadPth & " " & output & " -l eng"
myshell.ShellExecute "powershell", vArgs:=argu
End Sub
Powershell window pops-up but do nothing and get closed..