General information
Title:
Loading data from text files.....???
Hi all,
In one of my applications, we need to import a fixed width flat text file with lines that are longer than the 254 characters. The import wizard will allow me to import the data into each field, but I can't seem to duplicate this using the append command for data in the file that occurs after position 254.
Eg
Data from position 1-100 goes into field 1 in my table
Data from position 101-200 goes into field 2
Data from position 201-254 goes into field 3
Data from position 254-320 goes nowhere but it needs to go into field 4...
It's really frustrating - but there must be a solution somewhere (I hope)....
Regards
Chris Kable
MotorLink Systems
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only