Data in Tables updates every 15 mins

[dadtofive]

I receive data every 15 mins in an Excel database format in the form of an
attachment to an email..

I would like to be able to use this file as a dynamic base file used in an
ACCESS file/program.

Any ideas on how to get this data in the email attachment into Access every
15-30 mins automatically?

 

[Tom Wickerath]

You will need to break this task into bite-sized chunks, and conquer each
task. I would start by trying out Helen Feddema's sample:

Saving Email Attachments to an Access Table (See # 123)
http://www.helenfeddema.com/access.htm

Hopefully, the structure of the spreadsheet remains constant (column names,
position of columns, etc.). It will also be helpful if the spreadsheets
include defined data ranges, which you can include as an optional parameter
in DoCmd.TransferSpreadsheet method.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________