VBA SQL Query from Cell

[LePig]

Hi I am trying to get data from a cell and need a little help.

sSQLSting = "SELECT * From (" & Sheets(SpreadsheetName).Cells(firstAddress, Colname + 2) & ")"

This is returning nothing?

Any help would be appreciated.

 

[Joe4]

What are your values of the SpreadsheetName, firstAddress, and Colname variables?

I would recommend using a MsgBox to see what it is returning, i.e.

MsgBox sSQLSting

and inspect it to see if it looks correct.

By the way, perhaps you have a typo. Note that you have sSQLSting and and not sSQLString.
You didn't post how you were using/calling this string, so we cannot verify that for you.

 

[Kyle123]

xposted here: https://www.excelforum.com/excel-programming-vba-macros/1222691-vba-sql-query-from-cell.html
and here: http://www.vbaexpress.com/forum/showthread.php?62164-VBA-SQL-Query-from-Cell

 

[LePig]

I have a msgbox and it is returning the following

SELECT * FROM (451)

but then i get a run time error, cannot find object 451

http://www.vbaexpress.com/forum/showthread.php?62164-VBA-SQL-Query-from-Cell&p=377422#post377422

https://www.excelforum.com/excel-programming-vba-macros/1222691-vba-sql-query-from-cell.html

 

[Joe4]

xposted here: https://www.excelforum.com/excel-pro...from-cell.html
and here: http://www.vbaexpress.com/forum/show...uery-from-Cell

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Please be sure to do this going forward.

 

[Joe4]

I have a msgbox and it is returning the following

SELECT * FROM (451)

but then i get a run time error, cannot find object 451

Surely, the name of your table isn't (451), is it?
What is the name of the table you are trying to pull data from?

 

[LePig]

it is not a table - i just want to get the info from a cell on a spreadsheet

 

[Joe4]

They why use SQL at all?

Maybe just something like:

MsgBox Sheets(SpreadsheetName).Cells(firstAddress, Colname + 2).Value

 

[LePig]

I have done that - I am using SQL because lots of people are going to accessing the file so thought a database approach would be better

 

[Joe4]

So where exactly are you trying to run this code from?
Excel VBA, a SQL View, a SQL stored procedure?