Create tables from excel using VBA

[lewatkin]

I have a rather large excel spreadsheet that is the schema of a database, no data. There are several tables and hundreds of fields etc. It has the table name, field name, field description, type and null information in different columns. Isn't there a way that I can use this information to create my tables automatically? I have searched and searched and knowing me, I have searched for the wrong keywords, but if anyone could provide any assistance that would be great. Thanks to all in advance

 

[RivetHed]

Yes you could generate the tables with that spreadsheet.

It's hard to know exactly how to code it without seeing the layout of your data though so post it up, also have a read up on Tabledefs in VBA help and on this forum as a starting point.

 

[lewatkin]

Hey - Thx for your reply. I just got it figured out. Probably not the way most would - I ended up transposing the rows into columns onto different worksheets, then manually imported those sheets - viola, tables created with minimal typing.

Thanks for the response

Lee