excel macro to generate sql code

I need a macro code that looks into an excel file and looks at two columns

Column A (ODSName) which has the field name

Column B (Field type) which has the field type (VARchar, INT etc)

I just need some simple excel macro that generates the sql code to create the table

for example

CREATE TABLE customer
(First_Name char(50),
Last_Name char(50),
Address char(50),
City char(50),
Country char(25),
Birth_Date date)