I tried to get some data from DB. I need get account information from my table – this type of information will depend on User. If he/she will insert account type = 1 -> he will get this information. How could I create query if it will depend on user: for example user could choose one or more account types
Tag: ado
Excel VBA – ADO Connection to MS Access DB – Filtering results
I have a MS Access Database where I store some information of products and I have these fields: ID, Customer Part No., Description, Price, Observations I also have an Excel file where I have a column called Customer Part No. and in this column I paste the Customer’s Part I want to filter. I need a way to make a
explain differences between two different updates
I have 2 different update queries, one I created: my colleague preferred this one: He can’t explain which one should be better and neither can I. The only difference I have, is that the update on the second query crashes when there are no results to update. Can anyone explain what’s the difference? Answer To sum it up: The first
What is the best SQL statement to query a table using Excel 2010 VBA with ADO (or vb.net with LINQ)
Table Name: employees Right now I am stuck on trying to figure out how to combine two of my SQL queries into one. Query #1: SELECT * FROM `employees` WHERE `name` = ‘BOB’ …