![]() ![]() The extracted metadata won't give you a complete REDCap data dictionary, but at least it's a start. 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.Surveys: How to pre-fill survey questions.What can REDCap Administrators do that REDCap end users can't?. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |