question

Marcial61 avatar image
0 Votes"
Marcial61 asked TvanStiphout answered

Conectar Excel a SQLite

Hola estoy intentando conectar Excel a SQLITE pero no hay manera.

Mi sistema: Excel 365 y Windows 10- 64 bits

Lo que tengo es lo siguiente:

With cnn

     .Provider = "msoledbsql"
     .ConnectionString = "DRIVER=" & Driver & ";DataBase=" & Ruta & Fichero '& ";": c_error = True
        
     .Open
    
 End With

Está instalado el driver "SQLite3 ODBC Driver" y la referencia Microsoft ActiveX Data Objects 6.0 Library.

Pero me da el error "invalid connection string attribute"

¿Alguien me puede echar una mano con esto?

Muchas gracias por anticipado.

office-vba-devdotnet-sqlite
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

TvanStiphout avatar image
0 Votes"
TvanStiphout answered

We speak English in this forum.

Perhaps this will help: https://www.connectionstrings.com/sqlite/

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.