TextFields method

Call before Export to specify list of fields to be exported as text. Returns True if successful, otherwise False.

Applies to

TableData	ArrData	RsetData	Xdata	XShared
✓

Parameters

Name	Type	Description
Field	ParamArray	Field names or numbers to export as text.

Export creates an Excel workbook to be used as a data source. The ACE database engine attempts to determine the data type of each field by looking at the first few records. Numeric data intended to be text is interpreted as a numeric type, which can cause a problem if later data in the column is not numeric. This is not a problem if the data originated in ArrData as data is correctly typed. However for Tabledata it is possible to specify fields which should always be interpreted as text whatever they contain, using the TextFields method.

Call with no parameters to protect all text fields.