title: I need a VBA script to run on excel to copy all my access tables columns in Excel sheet
body: <p>I have about 10 *.mdb Access files of office version 2003. I am working on client machines on which I have only Excel 2003 installed but not Access. </p>
  
  <p>Each database file has around 50-100 tables in it and each tables has around 20-30 columns. I need to run a VBA script or any import on Excel so that I could copy all the Access tables and its columns into my Excel sheet. I do not require data of Access tables only the table and its column names is what I require.</p>