January 30, 2006 at 11:00 pm
I am attempting to import a text file of format:
| |plan_no |lot_no|unit_n|unit_s|street|str_no|street|str_no|road_name |road_t|road_p|locality_name |la_name | |
| |AP9645 | 1| | | | | | |SPLITTERS CREEK |RD | |HAZELDEAN |KILCOY | |
The rows are {cr}{lf} seperated, but the columns are fixed length and with | seperation.
If I use the Fixed Field option and specify column positions, I get a duplicate column error.
If I use the Delimited option and specify | as the text qualifier, I get an Invalid Delimited Data error.
Is this format of data able to be imported?
January 31, 2006 at 8:38 am
Since you have street field in the data twice, that is probably where the duplicate column error is coming from. I suggest not marking the 'first row has column names' and let SQL name the columns. Then you can go into the table and rename the fields in order to get a Street1 and Street2 field?
Michelle
January 31, 2006 at 3:26 pm
Duplicate column names it was - just like the error said. 'doh! Thankyou.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply