I’m trying to connect to a SQL Server from multiple PCs in the same domain. When using the following code: conn.Open returns the error: Error on login for the user ‘XXXX’ Answer The issue is because you are using a named user with Integrated Security. These two modes are incompatible. Try removing Integrated Security=SSPI: Or the named user:
Tag: excel
bad date format for pivot
together I can not figure out why in PowerPivot or Excel a Microsoft query does not provide the date fields in the format for Excel as they are necessary. I have already gotten from you in another …
Translate Excel business logic to T-SQL
I need to ‘translate’ some business logic from Excel to T-SQL, I’m having a hard time with it. It’s about figures from gates that count how many customers go IN and OUT of the stores. All DATA you …
‘CREATE TABLE’ generates Run-time error ‘3290’
I have a syntax issue in the first CREATE TABLE statement. I’m receiving the following VBA error: Run-time error ‘3290’ The goal is to move the distinct data to a new table dependent on values in …
Transfering Data with VBA(Excel) to SQL Server but avoiding duplicate column?
My main objective is to transfer some data from excel to SQL server while using vba but in the process I would like to detect and avoid transferring some duplicate month columns. This is what i have …
VBA Function/ Code – Convert Dynamic Column of Data into Text String
I’m creating a tool where users can query an ODBC through excel. I need a function which will look at a column of item id’s which the user has pasted in and then create a text string which can be used …
Error 424 object required after NULL SQL query
I am running some EXCEL VBA code to update the contents of an ACCESS database table along the lines suggested here: IF @@Rowcount = 0 — SQL Syntax Error in Access . When I execute the SELECT query, …
Carriage Return in Table Header
I’m writing an Excel macro to pull in data from another Workbook. I don’t have any control over that workbook, which is a shame because then I could fix this issue at source, as it is i have to work …
Excel VBA with SQL : No row returned when Where clause specified
Here below an excerpt of my codes. This is the SQL command : Where the database located : The variable containing the string connection to the DB : The wrkSheet for the result : This command Adding QueryTable as a ListObject returns ZERO occurrence because of Where Clause whereas the SQL is OK. If the Where Clause is removed, it
VBA SQL: Syntax Error in From Clause, Double Inner Join with Password
I’m reasonably new to SQL and I’m trying to create a string that collects the following: Code from [Catalogue Info] as c Description from [Product Information] as p Weight from p PPB from p CP-UK …