Gustav Brock
Gustav at cactus.dk
Thu Jul 16 09:36:51 CDT 2009
Hi John Yes, that is "fun". For reasons like this, I never use the TransferText method. However, could it be that Name is a reserved word? What happens if you use Drug_Name instead of Drug Name? /gustav >>> jwcolby at colbyconsulting.com 16-07-2009 16:26:27 >>> You will love this one. Place the following text into a text file and run a transfer text on it: R4inc quarter,20083,,,,,, NDC,Drug Name,Rebate Amt Due,#Rx,State Paid,Quantity,Formula,Unit Price DoCmd.TransferText acImportDelim , , "RawFormat", "YourPath\YourName.csv" the following is what I get: PK F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 F11 F12 26361 R4inc quarter 20083 26362 NDC Rebate Amt Due #Rx State Paid Quantity Formula Unit Price Notice that the "Drug Name" data item in the second row dropped out. Now, try this one: R4inc quarter,20083,,,,,, NDC,Drug Name,Rebate Amt Due,#Rx,State Paid,Quantity,Formula,Unit Price 597001314,COMBIVENT AER,0,5,513.01,73.5,2: 7.66735 - 3.1734 - 4.6244,0 The following is what I get. F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 F11 F12 R4inc quarter 20083 NDC Drug Name Formula 597001314 COMBIVENT AER 0 5 513.01 73.5 2: 7.66735 - 3.1734 - 4.6244 0 Notice the dropping of TONS of data items in the "field names" row. But hey, why fix the bugs in Access when there are pretty toolbars that need designing eh? 8( -- John W. Colby www.ColbyConsulting.com