EasyXLS

DataType.bas

Attribute VB_Name = "DataType"
Public DATATYPE_NUMERIC As String
Public DATATYPE_STRING As String
Public DATATYPE_DATE As String
Public DATATYPE_BOOLEAN As String
Public DATATYPE_ERROR As String
Public DATATYPE_AUTOMATIC As String

Sub Initialize()
    DATATYPE_NUMERIC = "numeric"
    DATATYPE_STRING = "string"
    DATATYPE_DATE = "date"
    DATATYPE_BOOLEAN = "boolean"
    DATATYPE_ERROR = "error"
    DATATYPE_AUTOMATIC = "automatic"
End Sub

EasyXLS Excel components:

.NET
Excel Library for VB6
full COM+ version to import, export or convert Excel files
Excel Writer for VB6
COM+ version to create and export Excel files
Excel Reader for VB6
COM+ version to read and import Excel files
Download EasyXLS™ Excel Component for VB6

File formats:

MS Excel 97 - 2003
MS Excel 2007 - 2019
MS Excel 2021
Office 365
XLSXXLSMXLSBXLS
XMLHTMLCSVTXT