check file layout diff with import spec

[Ronald_yoh]

HI There,

is there any way to check via VBA code if the file layout is having different name with the ones specified in import specification?

for example, in "import specification fileA", the first header field is First Name but while the file that is going to be imported contains surname in the first field.

thanks
R

[orange]

If you include the option 'First Row contains field names' then I think it would be a problem.

An option:
You can change the name of the fields in the specification as you wish, then save the import spec with a new name--say ImportSpec99. Then you would have import specification fileA and another import specification named ImportSpec99 or whatever it was you saved. Then just used the new spec.