Importing Data via Database Query
I am successfuly importing data into Excel from an Access query, and have
used the "Import External Data" function within Excel to do so. My spreadsheet imports a list of employee numbers and names in columns A and B, and in columns C through X the spreadsheet is used to track daily sick time leave taken. I have set up the data import query to add a new row when an additional record is found in the query. My expectation was that when a new employee name is found, the entire dataset would shift down by one row when the new row is added. Is my expectation incorrect, or am I doing something wrong, because the sick time data does not "follow" with its appropriate employee when a new employee name is found. Any assistance would be greatly appreciated. |
All times are GMT +1. The time now is 05:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com