I have a large data base in Microsoft Access (2016) where some variables contain Georgian characters. I need to import the data tables into R and have done that with the odbcConnect command.It works fine, however, the Georgian letters are not displayed properly but appears as "??????" in R. I guess this is an encoding problem and have spent 2 days browsing the web for solutions but are not even near to find one. I have tried to set the encoding to UTF-8 in R and the local language settings to Georgian (Sys.setlocale("LC_CTYPE", "georgian"), however it does not help, even though it seems to work for other foreign characters, such as chinese and russian letters. Any suggestions?
If I export the Access file to Excel first and then import it into R, it works fine, however, my dataset is so large that I then need to do it piecewise because of the upper limit of ~65000 rows in excel/tab-delimited files if I tick the box "Export data with formatting and layout" in Access which needs to be ticked, otherwise I loose the Georgian characters.
Anyone that have approached the same problem with microsoft access and know how to get around it? Any suggestions are highly appreciated.
I am sorry if I have missed out of any questions that have the solution for my problem. I am not a programmer and have never been dealing with these kinds of problems before so this is a real challenge for me.
Many thanks in advance,
Charlotta Rylander