Home |
Search |
Today's Posts |
#1
|
|||
|
|||
MSQuery won't show columns
Hi All.....
I'm trying to do a Query from Excel into an Access database to extract some data. Normally, the dialog box shows the table names in the left window with a plus sign and when you click on one, the plus sign changes to a minus sign and it drops down to show the columns therein...........this one changes the sign ok, but does not drop down to show any columns...........this procedure works fine on another database, any idea what might be wrong here?....... TIA Vaya con Dios, Chuck, CABGx3 |
#2
|
|||
|
|||
Ok, I got it........for those interested, it was a "security thing".....once
the security was stripped out of the database, the Query from Excel worked fine. Vaya con Dios, Chuck, CABGx3 "CLR" wrote: Hi All..... I'm trying to do a Query from Excel into an Access database to extract some data. Normally, the dialog box shows the table names in the left window with a plus sign and when you click on one, the plus sign changes to a minus sign and it drops down to show the columns therein...........this one changes the sign ok, but does not drop down to show any columns...........this procedure works fine on another database, any idea what might be wrong here?....... TIA Vaya con Dios, Chuck, CABGx3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
formula to show ranges in columns | Excel Worksheet Functions | |||
Show values from non-subtotaled columns when doing a sub-total? | Excel Discussion (Misc queries) | |||
add a column to a pivot table that would show the difference between 2 other Columns | Excel Worksheet Functions |