Import from Access - Excel spreadsheet automatically..
I have a xls spreadsheet that I receive every hr. This speadsheet is ran from another group and placed on my W: drive. Manually from Access 97 I import the xls speadsheet. I need to do this every 4 hrs... Does anyone have any suggestions on how I can do this through code either in Access or in VB code?
I want to eliminate the manual labour..
Re: Import from Access - Excel spreadsheet automatically..
Quote:
Originally posted by JohnSmith
I have a xls spreadsheet that I receive every hr. This speadsheet is ran from another group and placed on my W: drive. Manually from Access 97 I import the xls speadsheet. I need to do this every 4 hrs... Does anyone have any suggestions on how I can do this through code either in Access or in VB code?
I want to eliminate the manual labour..
another idea....
do they email the file to you or do they just place it on your "W" drive?