Import from Access - Excel spreadsheet automatically..

[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..

[NewBeeProg]

Yes, If you are doing this manually you can go to your tools menu and run the macro recorder and turn it on. As you manually get your data it will record your key stroke and menu picks. Just stop the recorder when done. It will ask you to make a hotkey for your macro like cont-a. I hope this helps

[texas]

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?

[JohnSmith]

Yes the xls is emailed to me. Is there a way to run this macro at a scheduled time ?

[texas]

Originally posted by JohnSmith
Yes the xls is emailed to me. Is there a way to run this macro at a scheduled time ?

You can auto launch the db when you get that email using a wizard in outlook and have it pick up the file from a predefined location.

Or set a scheduled task in windows.

Otherwise I would think the db would always have to be open and have some sort of form with a built in timer that runs all day and launches events at predetermined times