sql - how to get input into an Jet OLE DB Query -

-

Background:

I am using Excel 2003

I have 2 Excel The files are (source, list), one essentially my source data. Second is where I am using excel "import external data" to get data in the second sheet. I am then using modified query so that I can use SQL for the query of my data and limit the data I am displaying.

My SQL query: 

  SELECT * ['master list $'] where [name] is like "brent%";

My question is, I have to have cell A1 an input in my query. So in A1, I have to "brent" to change the first WHERE condition.

I hope to find something that I change to a cell and

Anyone have an idea?

Thank you.

My connection string is: 

  Provider = Microsoft.Jet.OLEDB.4.0; User ID = Admin; Data source = C: \ My data \ Master list \ Master list. Xls; Mode = share prohibition; Extended property = "hdr = yes;"; Jet Olendi: System database = ""; Jet Olendi: Registry Path = ""; Jet Olendi: Engine Type = 35; Jet Olendi: Database Lock Mode = 0; Jet Olendi: global partial bulk ops = 2; Jet Olendi: Global Bulk Transactions = 1; Jet OLEDB: New Database Password = ""; Jet OLEDB: Create System Database = Incorrect; Jet OLEDB: Encrypt Database = Incorrect; Jet OLEDB: Compact = Do not copy Locale on Local; Jet OLEDB: Compact Without Replication Repair = Wrong; Jet OLEDB: SFP = False    
 
 
 You accidentally created  FROM  Keywords in your query. 
 
 Because you are asking for an Excel workbook, it is best to ensure that it is turned off; You should be aware of using wet DB as well Also, know how Excel determines the type of data, which can be a little strange with the  NULL  s appearing unexpectedly; More info on 
 
 You have not specified a worksheet, so I assume that it has been named  Sheet1 . 
 
 Your too many connection strings have been created; Default values ​​can be removed and deleted. 
 
 Because it is a programming site and you are asking about Excel, about some VBAs How to: 
 
  sub-excel exploration () Const CONN_STRING string = _ "Provider = Jet as Microsoft. OLEDB.4.0; User ID = Admin;" & Amp; _ "Data Source = C: \ My Data \ Master List \ Master List. Xls;" & Amp; _ "Mode = write share prohibition; expanded properties =" "HDR = yes;" ";" & Amp; _ "Jet Olendi: System Database =" "" Jet Ondi: Registry Path = "" ""; " & Amp; _ "Jet Olendi: Engine Type = 35; Jet ALLDB: Database Locking Mode = 0;" & Amp; _ "Jet Olendi: global partial bulk ops = 2;" & Amp; _ "Jet Olendi: Global Bulk Transactions = 1;" & Amp; _ "Jet Olendi: new database password =" "" ";" & Amp; _ "Jet Olendi: create system database = false;" & Amp; _ "Jet Olendi: encrypt database = false;" & Amp; _ "Jet Olendi: Compact = Do not Copy Locale on Fail;" & Amp; _ "Jet Olendi: Compact Without Replication Repair = Wrong;" & Amp; _ "JetLLDB: SFP = False" "SQL_act String as Structure = _" Select * From ['Master List Dollar'] Where Is [Name] Like? "CMD Set CMD = Create Object (" ADOB. Command ") with CMD. Active Connection = CONN_STRING. COMMAND TEXT = SQL_ITIR DEAM PARAM SET PARAM = Object (" ADODB.Pamator ") with Ultimate Direction = 1 'Adapter Input. Type = 202 'adverkey size = 255. Features = 64' adParamNullable.value = thisWorkbook.Worksheets ("Sheet1"). Range ("A1") with value and "%" end. DM RS Set RS = Create Android with Object ("ADODE Rebecca ") with RS set. Source = CMD.Open 'Record with accessories ... End with End & End  
 
 UPDATE 
 
 Which parts of the connection string are useless? To a great extent! For example, the default user is the administrator but the Jet Workgroup file is an empty string because Excel does not use Jet security. I  think  the connection to Connection string without changing Programming can be reduced to: 
 
  in CONN_STRING string as String = _ "Provider = Microsoft.Jet.OLEDB.4.0;" & Amp; _ "Data Source = C: \ My Data \ Master List \ Master List. Xls;" & Amp; _ "Extended Properties =" "HDR = Yes;" ";"

Comments

Post a Comment

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

-
I'm new to this I'm writing a clr. stored procedure that can be used to get values ​​used in a calculation Call for another stored procedure for Gives an archived methodology int (I think SqlInt32? Value of the table's value is int) which is then necessary to convert to decimal. Here I have the code: Public static integral mood (SQL MDMMYLUE, escalistering AMY type, out of SQLDCM Result) {aResult = 0; Try {SqlConnection conn = New SqlConnection ("Reference Connection = True"); SqlCommand cmd = New SqlCommand ("sp_GetType", conn); Cmd.Parameters.AddWithValue ("@ myValueType", aMyValueType); Cmd.CommandType = CommandType.StoredProcedure; Conn.Open (); Object type = CMD. Exclamation Asser (); Conn.Close (); Decimal type FORCalculation = Convert. ToDecimal (type); Decimal value = convert toDecimal (aMyValue); // ** calculation calc = new calculation (); Decimal result = calorie.docalulation (typefarculation, value); I get an exception...
Read more

Calling GetGUIThreadInfo from Outlook VBA -

-
I need to find the active window'm writing a VBA macro in MS Outlook, which is a specific process. The goal of this is to get the active window / document name even if its original application has more than one document interface. User processor with GetCurrentThreadId is active, I am using GetGUIThreadInfo to get .dll. Here is the correct code: private type RECT as as Left LongPtr top LongPtr right LongPtr down LongPtr termination of private type GUITHREADINFO cbSize as LongPtr flags LongPtr hwndActive LongPtr hwndFocus LongPtr hwndCapture LongPtr as as as as as reset as LongPtr rcCaret as LongPtr hwndCreate as LongPtr hwndMoveSize as HwndMenuOwner end of Private Equity PtrSafe function GetWindowThreadProcessId Lib "user32" (_BVV hnw LongPtr as LongPtr Nig Mr. announced as PtrSafe function GetGUIThreadInfo Lib "user32" _ (ByVal dwthreadid as LongPtr, _ lpguithreadinfo as GUITHREADINFO) LongPtr Sub MyFunction () as dim strWindowTitle string = space as s...
Read more

Obfuscating Python code? -

-
I'm looking for a way to hide my Python source code. print "Hello World!" How can I encode this example so that it is not human-readable? I have been asked to use Base 64 but I'm not sure how. itemprop = "text"> It is limited only, first level ambiguous resolution, but has built-in: byte-code in Python Is a compiler for: dragon-o-m py_compile & lt; Your program.py & gt; creates a .pyo file with a byte-code, and where the docstrings are removed, etc. You can rename .pyo with the .py extension, and python & lt; Your program.py & gt; runs as your program, but it does not have your source code. PS : If your program blur modules like this, you need to rename them with the .pyc suffix (I Not sure it will not break a day), or you can work with .pyo and run them with python -o ... .pyo ( Import should work). This will allow dragon to search your modules (otherwise, Python looks for the .py module).
Read more