>Terry,
>Are the first row of that file:
Record Type|Unique Reference Number|TOID|TOID Version|Name|... is related to your table structure? Is there anything you use from that row to find what field you must fill?
Hi Borislav
With my Import command I'd relied on their position to get the correct data in the correct (similarly positioned) fields in my intermediate table, assuming that OS PointX data files always have the same format. Then I delete the 1st record to get rid of the record that holds the column headers.
Then I find, in the latest file to import, even the header names are different, e.g.
"UNIQUE_REFERENCE_NUMBER" cf. Unique Reference Number",
"TOID_VERSION" cf. "TOID Version" etc.
This is a PITA
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.