Hi All

I have a major excel database which one day I hope to find a way to store in an access database but do the data entry from excel (another question for another time). In the meantime I am trying to loop through all the worksheets and export them to access. The code below works in that it create's the database and exports the data with the name of the active worksheet BUT it only ever copies the data from the same worksheet. In other words I get 6 tables with different names but all with the same data. I am assuming that it has something to do with the range but I cannot get a syntax that works.


Please Login or Register  to view this content.
Your help would be appreaciated.
Thanks
Steve