Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems using MS Query to access an Excel file
I imagine there are easier ways to work with this, but I want to use
"queries" on a set of data which is currently in an excel file. However, when I try to do: Data/Import External Data/NewDatabase Query/Excel Files ... .... on the excel file. I get the following error message from Microsoft Query: "This data source contains no visible tables" What am I doing wrong? How do I set up the excel file so that it is clearly seen as a table? [It all works well when I do something similar with a very similar an Access db file.] Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems importing from an Access query | Excel Discussion (Misc queries) | |||
Run Access query from Excel, input value to query being value in c | Excel Programming | |||
VB Code or Excel macro to run Query/Import on Access file | Excel Programming | |||
Link Access query to refresh an EXCEL file | New Users to Excel | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |