>hi ,
>thank you for reply and help,
>
>is there away to add newfield to my table and put it as first field at my table vai alter
>ALTER TABLE alldat ADD COLUMN num n(9) && as first field
>
>thanks.
Not with ALTER TABLE - AFAIK, this command will always add fields at the end.
Basically, you can create a new table and copy data from the old table. I suggest that for importing data from Excel, you copy to a temporary table first.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)