ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I get right use on New Database Query (https://www.excelbanter.com/excel-programming/329226-how-do-i-get-right-use-new-database-query.html)

Ada

How do I get right use on New Database Query
 
I followed the steps provided by the Training course of Microsoft Office
online. But I could not run it properly. I am not sure whether it is a
problem on choosing data source as excel file then click ok, it was asked me
to select the spreadsheet, I did it but message box shown no visible table.
How can I do?

Thanks

WindsurferLA

How do I get right use on New Database Query
 
The following is speculation based on some of my experiences. Look into
whether or not the link is dependent on Microsoft® Open Database
Connectivity (ODBC). My understanding is that Microsoft updated the
ODBC files a while back to eliminate certain vulnerabilities to computer
worms and viruses. After they were updated on my computer, my Office97
Word mail merge procedures would no longer work with dbaseIII files.
I've since gotten mail merge to work with an Excel data base, but it
does not use the ODBC link.

Is your version of Office compatible with your present ODBC files?

Ada wrote:
I followed the steps provided by the Training course of Microsoft Office
online. But I could not run it properly. I am not sure whether it is a
problem on choosing data source as excel file then click ok, it was asked me
to select the spreadsheet, I did it but message box shown no visible table.
How can I do?

Thanks



All times are GMT +1. The time now is 08:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com