Hi,
I am very new to this. I have taken over the responsibilities In my organisation of ensuring that any excel files imported to access can be viewed on an excel spreadsheet which uses a macro.
The steps involved are:
1. Excel file imported to Access.
2. Users have an excel spreadsheet which pulls the information from Access.
From time to time the table could be missing one row to anything up to 400 rows. I have gone through the source excel file and everything seems fine for import, the files import successfully and they can be viewed in Access. I am not sure if there is an issue between the Excel spreadsheet pulling the info from Access because, as I said, this happens from time to time. If the user who imports the excel file notices that there are rows in a table missing in Access, they will import the file again and all rows will appear but the user may end up having to do this repeatedly which is a waste.
Has anyone experienced this?