Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | "Puddicombe, David" <David.Puddicombe@bccdc.ca> |
| To | "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu> |
| Subject | st: odbc load variable not found |
| Date | Fri, 25 Oct 2013 11:28:05 -0700 |
Hello, I am trying to import data from an access database table to stata using odbc load. There are a few variables in the access database table with a full stop/period in the variable name, which it seems cannot be loaded into stata using the odbc load command: - Main_Form.IDNUM - Main_Form.Genotype - Lab_PCR.Genotype - Vaccine.IDNUM The command I am using is below. It works if I exclude the variables listed above with the '.' in the variable name. odbc load /// primarykey="Primary Key" /// main_formidnum="Main_Form.IDNUM" /// casereport="Case Report" /// ... , table(data_export_all) Is it possible import the variables with '.' in the variable name? Thanks, David Puddicombe david.puddicombe@bccdc.ca * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/