Search results 27

Sorted from new to old.

DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

May30

DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

Mar12

Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

2024Feb8

ConcatenateStrings_AmongString

Collect strings matching search from a longer string. I used it to concatenate ...

2024Jan17

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

SendEmailMsgv2023

Sending email using Microsoft 365 account. Edit 2024-12-19: Fixing ability to ...

2023Nov12

USB format in Android

What is the best format to use a USB storage for using in Android phones and ...

2023Sep28

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

Arabic in MySQL

Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...

2023Apr12

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

2020Dec11

NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

2020Mar31

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20

List of Databases

Script to list databases available in a server using ADODB connection From

2019Oct6

1 2