View Single Post
Old 10-03-2016, 04:14 PM   #5
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,347
Thanks: 40
Thanked 3,670 Times in 3,538 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Get specific cell data from multiple workbooks for import into MS Access

a couple of years ago I was tasked by a client to import some 10000 spreadsheets generated over a 5 year period.

During that time the format changed - rows were added or deleted so the first 'item' was not on the same row

additional columns were added. Some values were 'annotated'. in some, numbers had been entered as decimals whilst in others they were integers. All depended on who had created the invoice.

In all, I identified some 150 'variants'.

My point is, check that your earliest invoice has exactly the same structure and layout as your last one and do spot checks in between.

If you are confident the layout etc is consistent, you can create some code in vba to loop through the files, importing them one by one.
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote