|
3MGrant5,
TRANSFERTYPE = "acExportDelim"
Is a constant representing a number, the value is only known to Access if the visual basic code
is executed from Access.
The value for "acExportDelim" is 2
You should change the line:
$TRANSFERTYPE = "acExportDelim"
To
$TRANSFERTYPE = 2
Access expects a number as transfer type not a string, that's why you get the "Type mismatch"
-Erik
| 
