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.

 

[LePig]

This code is being run on a commandbutton on a userform - excel vba

 

[Joe4]

If you are using Excel VBA, I do not understand why you would want to involve SQL code at all.
What is the relation of the data you are trying to extract from the Excel file that the userform and code is stored in.
Is it the same?
If not, how does the SQL code know where to look to find this file?

 

[LePig]

The best approach is for me to use a database I just need a little help. Nevermind - i shall work it out.

 

[Joe4]

We are trying to help you, but we are trying to understand your whole structure here. You really haven't provided very much details as to how all of this is laid out, and how everything is connected.

 

[Joe4]

If you are interested in using a Database structure on Excel data, I would recommend looking into MS Query.
See: http://www.exceluser.com/formulas/msquery-excel-relational-data.htm
and http://analystcave.com/create-microsoft-query-excel-excel-query/

I have never used it before, but have seen others do it (personally, if I had this type of situation, I would probably just use Microsoft Access - form creation is so much easier there).

 

[Fazza]

to reference a worksheet named "whatever" use this syntax

SELECT field names
FROM [whatever$]