I need to import the data from a Access file to RentHIstory.xls without
changing any fields on the Excel file.(see attached)
The problem is that the Excel file has only 65000 rows and the Access file has
over 250000, so I was thinking that having more then one sheet on the Excel file will help but I didn't manage to have a macro that will direct the import from one sheet to the other in the file RentHistory.![]()
Thank you all in advance.
Bookmarks