L
LanceR
I'm doing an export from an Access table using
DoCmd.TransferText acExportDelim, "SpecName", "TableName", "Path", False
In the Access table I have values in the column "paid_amount" such as -$10.00
The column is defined as Currency with Format $#,###.00
When exported to the TAB file the value becomes (10.00)
The MSysIMEXColumns table shows DataType for this field of 5.
Is there any way to keep -$10.00 from changing to ($10.00) during the export
process?
This is creating problems with the next step which is to move the tab file
into SQL.
Thank you for any assistance !!
DoCmd.TransferText acExportDelim, "SpecName", "TableName", "Path", False
In the Access table I have values in the column "paid_amount" such as -$10.00
The column is defined as Currency with Format $#,###.00
When exported to the TAB file the value becomes (10.00)
The MSysIMEXColumns table shows DataType for this field of 5.
Is there any way to keep -$10.00 from changing to ($10.00) during the export
process?
This is creating problems with the next step which is to move the tab file
into SQL.
Thank you for any assistance !!