Hello, I want to transfer the database from SQLite to Access.
I generate SQL file - everything is OK. But I can not execute it on Access.
Google did not help, unfortunately.
With the encoding in the SQL file is also a problem. The database contains a dictionary in German, where there are umlauts (Ü, ä ...) which are not preserved in this form.
Tell me, please, how to be in this situation?
PashaPash ♦
42.5k 9 60 130
Rakzin Roman Rakzin Roman
3.241 7 47 119
- Isn't it easier to export from sqllite to something more portable? for example in csv or xls (x). In Access, it seems even the import function was from these formats - Alexander Moshnov
|
2 answers
- Use UNICODE encoding for upload.
- To download SQL scripts, you can use the utility http://www.rsdn.ru/article/files/progs/BatchAccess.xml
mr_jumper mr_jumper
351 one 6
|
If there is an ODBC driver for sqlite, then I would try to import the database from Access.
msi msi
11k eleven sixteen
|