Check Datatype and Field size in code

Design by Sue

Registered User.
Local time
Today, 03:22
Joined
Jul 16, 2010
Messages
816
I have created code to import and excel file and create a table from that info. Now I need to confirm that the import has the correct Datatype of Number and Fieldsize of Double for one of the columns. Any thoughts on how to do this in vba?

Thanks
Sue
 
Thank you CJ - exactly what I needed!
 

Users who are viewing this thread

Back
Top Bottom