Export Data from the Attendance Sheet to Microsoft Access Database
Good news to users who are using Access database software. By using the TCMS V2 software, you can now export data from the Attendance Sheet into Microsoft Access Database format. There are various types of third party software out there using Access database to process data. Upon setting up the ODBC manager, the TCMS V2 can easily export data into different file types as required for input into their third party system. Today we will discuss about how to set up the ODBC manager in the Windows 7 platform and export data from the TCMS V2 Attendance Sheet into Microsoft Access Database.
Go to Start > Control Panel > Administrative Tools.
Double click Data Sources (ODBC).
Click “Add” button at the User Data Source (User DSN).
Select Driver do Microsoft Access (*.mdb) and click “Finish”.
1. Insert the data source name, example: Export Data
2. Click “Select”.
3. You can download the sample database here.
Choose the Sample Database.mdb and click “OK”.
Upon selecting the database path, click “OK” to proceed.
Click “OK” again to exit the ODBC Data Source Administrator.
Start up the TCMS V2 software > Attendance Sheet > click “Export”
Select the Employee ID and date range > choose either Export Detail or Export Summary.
1 - Select the data source name (Export Data)
2 - Insert in the Table Name, example: Export Data 1
3 – Click “Test Connection”.
Click “OK” when you see “Test Completed Successfully”.
Click “Save” to save the configurations and go back to Export Attendance Records.
Lastly, click “Export Detail” to export data from the Attendance Sheet into Microsoft Access Database.
When you open the Microsoft Access Database, the export details result will show as per below.
Please take note; if you are using 64bit operating system, you need to go to
C drive > Windows > SysWOW64 > double click at odbcad32.exe to add the database at the User Data Source.
( C:\Windows\SysWOW64\odbcad32.exe )
Initiated and Written by : Faiz
Hi, I want to export attendance data to ms sql database same as above steps. Is possibleReplyDelete
Hi Karthi Raju,ReplyDelete
Good day to you.
The TCMSv2 can't export the data directly to MSSQL. You will need to export the data to access database and the MSSQL can read the data from the access database.
Positive site, where did u come up with the information on this posting? I'm pleased I discovered it though, ill be checking back soon to find out what additional posts you include. VoIP TelecomsReplyDelete
We are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work. door access control systemReplyDelete