Using a TableName instead of Named Range in Excel datasource SQL Query -
In Excel VBA, I'm using Excel as a data for some queries. I am using the query
sq = "[choose from name 1]" - this works
But, instead I have the table I want to use the name Nammalang (Excel 2007 Tables) how do I use it? I tried to select from "[Table 1]"
and I also tried to make a nimereng for this table 1 and did not work either ..
Any thoughts please?
You do not say that you are using the DAO or ADO to connect, but I do not think this is the case. I do not think it is possible to mention a table I have seen that all the documents list three types of categories: an entire sheet [sheet 1 $], the nominated category [nomre1], or an anonymous boundary [sheet 1 $ A1: B10].
I am able to give an Excel 2010 table a named range containing the header and that acts like any other named category, and it changes shape with the addition of lines Do that, if it's named a sheet level, then you do it like [Sheet 1 $ name category 1].
Here is the best information I found when doing this with the ADO:
Comments
Post a Comment