Message 1 of 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hi,
I installed both 32 and 64 bir SQLite ODBC driver from here. I used this code in VBA but "Out of Memory" error appear.
When I use 32 bit DSN then "wron architecture" message appear. My machine is 64 bit.
Dim conn As Object, rst As Object
Dim strSQL As String
Set conn = CreateObject("ADODB.Connection")
Set rst = CreateObject("ADODB.Recordset")
' OPEN CONNECTION
conn.Open "Dsn=SQLiteDatasource64;Database=c:\Kurdak.db;Version=3;"
strSQL = "SELECT * FROM test "
' OPEN RECORDSET
rst.Open strSQL, conn
' OUTPUT TO WORKSHEET
Debug.Print rst
rst.Close
' FREE RESOURCES
Set rst = Nothing: Set conn = Nothing
Where am I wrong?
I wish we have "table and search in table utilities" in VBA. 😞
Regards,
Mucip:)
Solved! Go to Solution.