MS Access tool that can check quickly verify the following in a sheet: number of columns, title of columns, and character type.

[dellion]

I receive excel worksheets from customers that are supposed to be in a certain format. I will be checking these worksheets for correct number of columns, correct headers of columns, and correct character types in each column. I was wondering if there were any tools/macro/Microsoft Accces Marcos that could make this process quick and easier.

 

[Joe4]

Cross-posted: http://www.mrexcel.com/forum/excel-...ber-columns-title-columns-character-type.html

 

[jolivanes]

See cross post at MrExcel