I have created a database query in a Excel worksheet. The query is taken from the customer_master table of the SQL server database China_main. After I have created the query, I view the query. I find that the sql statement as 'Select customer_id from China_main.dbo.customer_master'. I cannot remove the China_main.dbo.. Can I change the China_main database by change the ODBC connection only. The Excel worksheet is with many data from many queries. I want just to change the ODBC default database, then the query will retrieve data from the changed database, e.g. China_gz. Do you have any suggestions?
