Returns or sets an ordered array of constants that specify the data types applied to the corresponding columns in the text file that you’re importing into a query table. The default constant for each column is xlGeneral. Read/write Variant.
You can use the xlColumnDataType constants listed in the following table to specify the column data types used or the actions taken during the data import.
| Constant | Description |
|---|---|
| xlGeneralFormat | General |
| xlDMYFormat | DMY date |
| xlDYMFormat | DYM date |
| xlEMDFormat | EMD date |
| xlMDYFormat | MDY date |
| xlMDYFormat | MDY date |
| xlSkipColumn | Skip column |
| xlTextFormat | Text |
| xlYDMFormat | YDM date |
| xlYMDFormat | YMD date |
Remarks
Use this property only when your query table is based on data from a text file (with the QueryType property set to xlTextImport).
If you specify more elements in the array that there are columns, those values are ignored.
You can use xlEMDFormat only if Taiwanese language support is installed and selected. The xlEMDFormat constant specifies that Taiwanese era dates are being used.