Hello,
I am having a problem with ODBC connection. I am using code:
odbc query "MS Access Database", dialog(complete)
odbc load, table("`var`i''")
export delimited using "`fvar`i''", replace
My purpose is to tell the ODBC connection where to get the database file programatically, and export the missing files.
But current code uses the dialog approach, which assumes there is a user to manually select the database.
My question is: Is there a way to connect to ODBC and telling where to get the database file without requiring an user to do it manually?
Thanks,
Jessica
I am having a problem with ODBC connection. I am using code:
odbc query "MS Access Database", dialog(complete)
odbc load, table("`var`i''")
export delimited using "`fvar`i''", replace
My purpose is to tell the ODBC connection where to get the database file programatically, and export the missing files.
But current code uses the dialog approach, which assumes there is a user to manually select the database.
My question is: Is there a way to connect to ODBC and telling where to get the database file without requiring an user to do it manually?
Thanks,
Jessica
Comment