Change Data type and name

[niftysam]

I allow the user to import a file where they select the name of the table and location of the excel file.

I need to add a few more lines of code that check to see that there is a zip code field and that its data type is a number field

Here is the basic idea, but I am so new to vb script that I have no idea how to go about this!! Thanks so much!!!

I know how to do this manually, but I am trying to make this as dummy proof and user friendly as possible.

if table has a field named zip code or zipcode
rename to zip
end if
if table doesn't have a field named zip then
err please import table with zip field
elseif zip code field data type isn't a number
change data type to number
end if