PDA

View Full Version : Import text file in different order



Yvaine
09-21-2008, 10:46 PM
At first, i manually import a text file by choosing "Get external Data" from menu. I created a specification. Then when i import it via transferText (include the specification name in the command), the records imported into table is different. Please note that whether i import manually or via transferText, i use the same specification. Any idea on the reason?

CreganTur
09-22-2008, 05:16 AM
the records imported into table is different.
What do you mean by 'different'? what exactly is happening to your data?

Can you provide any example data for us to look at?

Slyboots
09-23-2008, 11:28 AM
Are you sure the TransferType is specified correctly in your code? (acImportDelim, acImportFixed, etc.)

S


At first, i manually import a text file by choosing "Get external Data" from menu. I created a specification. Then when i import it via transferText (include the specification name in the command), the records imported into table is different. Please note that whether i import manually or via transferText, i use the same specification. Any idea on the reason?