Database 61 To deal with database and maintain it

Card image cap
DB_Connect

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

Card image cap
Reset ID Column

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

Card image cap
ANSQLWherein

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

Card image cap
List of Databases

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

Card image cap
Country list in arabic

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

Country-list-arabic-master.zip

Card image cap
Rows 2 Cell

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

Card image cap
DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

Card image cap
LastInsertedID_SQL

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

Card image cap
ANmaDB functions

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

Card image cap
DBMySQLVBA API

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

dbmysqlvbapi.zip

Card image cap
DB Class

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

Card image cap
Split string into table

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