We currently have an MS access dbase however we would like to know:
1. How to determine the charset or encoding of our MS Access Dbase?
2. How to convert our MS Access dbase to UTF8?
We are using the following MS Access.
1. Microsoft Office Access 2003 (11.8321.8341) SP3
2. Microsoft Office Access 2007 (12.0.6535.5005) SP2 MSO (12.0.6562.5003)
3. Microsoft Office Access 2010 (12.0.6423.1000)
And we would like to know how to do the actions mentioned above on all 3 versions of MS Access.
The reason is because we store some website data in our MS access database and copy them to directly to our webpages by:
a. copying the data from our database via copy-paste command in windows.
b. automated script to extracts the data from our database and copy the data to our webpages.
c. Exporting data to csv file and extracts the data from our csv file to the webpages.