[AccessD] TransferText wierdness

Charlotte Foust cfoust at infostatsystems.com
Thu Jul 16 11:43:30 CDT 2009


That's why you create import/export specs, John.  You know that.

Charlotte 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, July 16, 2009 7:26 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] TransferText wierdness

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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list