Database 61

To deal with database and maintain it

Sorted from new to old.

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

RRRow - Datatables ASP mdb Ajax example

ASP based AJAX example to call mdb database using

2020Sep7

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

Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

2020Feb9

ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

2020Jan6

List of Databases

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

2019Oct6

Country list in arabic

List of countries codes and names in Arabic, you do not know when you need it ...

2019Sep9

Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

2019Jul22

LastInsertedID_SQL

Get the ID of the last inserted record in a table. There are other methods, ...

2019Jul18

ANmaDB functions

Database functions, commonly used in my systems. Should be working for each ...

2019Apr14

DBMySQLVBA API

An API to allow connecting to MySQL database from VBA (or VB6), found it a ...

2019Feb3

DB Class

Database Class in Classic ASP An old article I found that helps a lot these ...

2018Dec25

Split string into table

Returns tag words (as table) in Microsoft SQL Separator set to comma, but you ...

2018Dec18

1 2 3 4