I have a problem where I am trying to export to a tab delimited text file
I have a query creating my data. I need to export a tab delimited .TXT file to upload to my data partner.
6 fields: SKU, Price, MinSellPrice, MaxSellPrice, QTY, LeadTime.
The first 4 fields export as formatted in the Query, but the last two magically convert to fixed format with 2 decimal places. These two fields are not accepted by my data partner with anything except integers. The first four always output exactly what is put in. Int in, Int out. Fixed 2 decimal in, Fixed 2 decimal out. Only the last two feel they have to convert. I use the transfertext to output to text from the query. I look at the data in the table view it is an Int. I converted my query to a make table query, my table has Integer in those same fields. I used the TransferText to export, same thing. The macro always converts those two fields to fixed with two decimals. I don't see where to make this change in the "Export Specification". I don't know VB and I struggle with SQL.
Any ideas to fix this would be greatly appreciated.
I have a query creating my data. I need to export a tab delimited .TXT file to upload to my data partner.
6 fields: SKU, Price, MinSellPrice, MaxSellPrice, QTY, LeadTime.
The first 4 fields export as formatted in the Query, but the last two magically convert to fixed format with 2 decimal places. These two fields are not accepted by my data partner with anything except integers. The first four always output exactly what is put in. Int in, Int out. Fixed 2 decimal in, Fixed 2 decimal out. Only the last two feel they have to convert. I use the transfertext to output to text from the query. I look at the data in the table view it is an Int. I converted my query to a make table query, my table has Integer in those same fields. I used the TransferText to export, same thing. The macro always converts those two fields to fixed with two decimals. I don't see where to make this change in the "Export Specification". I don't know VB and I struggle with SQL.
Any ideas to fix this would be greatly appreciated.
