![]() ![]() Table names can be queried from the hidden system table "MSysObjects", and a table's metadata can be accessed in VBA using the Fields collection of a DAO Recordset, ADO Recordset, or DAO TableDef. You can also extract this information yourself using MS Access. For example, there are a few options to get metadata out of MS Access to facilitate the creation of a REDCap data dictionary:įor Access 2003 or earlier, there is a third-party software (CSD Tools) that can export field names, types, and descriptions to MS Excel. ![]() It depends on the project design and application you are transitioning from. General Can I transition data collected in other applications (ex: MS Access or Excel) into REDCap? List of functions for logic in Report filtering, Survey Queue, Data Quality Module, and Automated Survey Invitations. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |