ezfriend
Registered User.
- Local time
- Today, 09:57
- Joined
- Nov 24, 2006
- Messages
- 242
I have a table with couple fields and define as follow:
File Format:
"RecordID","Author","Recipient"
2929929,"Author1,Author2,etc..","Recipient1,Recipient2,etc.."
2929930,"Author1,Author2,etc..","Recipient1,Recipient2,etc.."
2929931,"Author1,Author2,etc..","Recipient1,Recipient2,etc.."
The Author and Recipient field tend to have a super long list of names, depending on the file so I define the field as type MEMO. I don't plan to sort these two fields or anything. These names are just simply there as text.
When I run the import wizard, all data will be imported to the table correctly; however, when using the DoCmd.TransferText, some records in the Author and Recipient fields got truncated even when the field is define as MEMO.
FYI: I have quite a bit of files with the same data structure so I loop through all files within the directory and import them in using the following code.
The List items contain full path and file names of these text file.
CODE:
Dim i as long
For i=1 to lvFileName.ListItems.Count
Any idea of why the data get truncated?
Thanks.
ez.
- RecordID Number
- Author MEMO
- Recipient MEMO
File Format:
"RecordID","Author","Recipient"
2929929,"Author1,Author2,etc..","Recipient1,Recipient2,etc.."
2929930,"Author1,Author2,etc..","Recipient1,Recipient2,etc.."
2929931,"Author1,Author2,etc..","Recipient1,Recipient2,etc.."
The Author and Recipient field tend to have a super long list of names, depending on the file so I define the field as type MEMO. I don't plan to sort these two fields or anything. These names are just simply there as text.
When I run the import wizard, all data will be imported to the table correctly; however, when using the DoCmd.TransferText, some records in the Author and Recipient fields got truncated even when the field is define as MEMO.
FYI: I have quite a bit of files with the same data structure so I loop through all files within the directory and import them in using the following code.
The List items contain full path and file names of these text file.
CODE:
Dim i as long
For i=1 to lvFileName.ListItems.Count
DoCmd.TransferText acImportDelim, , "Data", lvFileName.ListItems.Item(i), True
NextAny idea of why the data get truncated?
Thanks.
ez.
