Hi,
I am using Stata 15 and Mac OS Mojave 10.14.2. I have multiple databases in .mdb format, and I would like import all the data (multiple worksheets in each database) into .dta format.
I know I can either use transfer programs like StatTransfer or use odbc commands.
For the second method, I am having trouble configuring odbc datasources. For this purpose, I downloaded iODBC driver after reading the manual -
https://www.stata.com/support/faqs/d...figuring-odbc/
but am not able to set it up properly. For instance, I do not which driver would be appropriate for these .mdb files, which I guess is giving me observations when I type odbc list.
Any suggestions on how to proceed would help. Thanks.
I am using Stata 15 and Mac OS Mojave 10.14.2. I have multiple databases in .mdb format, and I would like import all the data (multiple worksheets in each database) into .dta format.
I know I can either use transfer programs like StatTransfer or use odbc commands.
For the second method, I am having trouble configuring odbc datasources. For this purpose, I downloaded iODBC driver after reading the manual -
https://www.stata.com/support/faqs/d...figuring-odbc/
but am not able to set it up properly. For instance, I do not which driver would be appropriate for these .mdb files, which I guess is giving me observations when I type odbc list.
Any suggestions on how to proceed would help. Thanks.
Comment