I am trying to get Microsoft Query to attach to a file which has Excel Tables set up (in Excel 2007). However, it cannot attach to the tables for some reason. Am I missing a step some where? this sucks please help. Here is the file.
I am trying to get Microsoft Query to attach to a file which has Excel Tables set up (in Excel 2007). However, it cannot attach to the tables for some reason. Am I missing a step some where? this sucks please help. Here is the file.
When you try to do the connection and MS Query doesn't show any tables, Click "Options" and select "System Tables" checkbox. It is ridiculous that Excel can't handle Excel tables as easily as Access / SQL Server / Oracle / ....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks