dbpath

Hi, cant figure out whats wrong here: This Works with the following SQL string in cell P9 SELECT * From [DataSheet$] WHERE Region='UK' But it fails with this, where the Region is in cell P7 SELECT * From [DataSheet$] WHERE Region='" & REGION1 & "' Sub Test2() Dim REGION1 As String, SQLSTR As...

Hi, i found this great code which allows you to query the current workbook, and also closed workbooks. Allows you to SQL query which i am finding a better way of "advanced filtering" data in the same workbook. Are there any limitations to this? Also if using ADO on an external workbook (closed...

I try to connect data from an excel file to another excel, the problem that I am facing now is the code that I get from gooling maximum can only import 256 columns. while my data has more than 400 columns. and this is what I have now: Sub CopyFromRecordset_To_Range() Dim sSQLQry As String Dim...

Hi, I am trying to run an MS Access queries from Excel but when I try to run the from Excel, it always asks for a password. I would like to remove the prompts / embed credentials so macro would run without any interruptions. Thanks in advance! AQuery is an Append Query that goes to ATable...

Excel friends, I am trying to read a CSV table using the following VBA code found in: https://analysistabs.com/excel-vba/ado-sql-macros-connecting-database/ I need help in three areas: 1) Can I read an external CSV table using this code? If so, how to setup a CSV file, InputData.csv, not an...