jonathanchye
Registered User.
- Local time
- Today, 20:55
- Joined
- Mar 8, 2011
- Messages
- 448
Hi,
My client gets sent a daily/weekly spreadsheet that have basicalyl the same format but the data and filename differs according to dates.
What my client wants to do is virtually "cut and paste" the selected data from this Excel spreadsheet and dump it into an MS Access database I have. I will have to then create reports from this data. Usually I will just link to the Excel spreadsheet and then create Data Macros etc but in this case the file itself changes...
Do you have any suggestion on what I can do in this situation?
My client gets sent a daily/weekly spreadsheet that have basicalyl the same format but the data and filename differs according to dates.
What my client wants to do is virtually "cut and paste" the selected data from this Excel spreadsheet and dump it into an MS Access database I have. I will have to then create reports from this data. Usually I will just link to the Excel spreadsheet and then create Data Macros etc but in this case the file itself changes...
Do you have any suggestion on what I can do in this situation?
