Question about Microsoft Excel for PC
I have a database on one machine access 2007 ans excel 2007 and when I try to refresh queries on another machine also excel 2007 and access 2007 MS Quey will not recognize any file type other than MDB. I need 12 machines to to run this spreadsheet. Ms query version (from About) version = 12.0.6211.1000 SP1MSO12.0.6320.5000. One copy sees mdb and accdb file one only sees mdb files?????
I have fixed my problem. I realised that the Microsoft Access Database DSN did not include the *.accdb driver. I deleted the existing DSN and created a new one. This allowed me to select the ODBC driver that worked for both file types.
I cameto realise that I was only having this problem on machines that have been upgraded to excel 2007 and not on machines with full virgin installations. On install both try to create the appropriate DSN but one with the same name already exists on the machines being upgraded and the creation fails.
I hope this helps others.
Posted on Jul 19, 2009
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Sep 09, 2015 | Computers & Internet
Feb 28, 2015 | Microsoft Office Access 2007 for PC
Feb 05, 2015 | Microsoft Office Professional 2007 Full...
Feb 26, 2017 | Microsoft Computers & Internet
May 05, 2011 | Computers & Internet
Jun 03, 2010 | Microsoft Office Access 2003 (077-02871)...
Aug 03, 2009 | Microsoft Office Access 2007 for PC
May 04, 2009 | Microsoft Excel for PC
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
104 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: