just thinking out loud on a import element

[GaryPanic]

Hi guys before I get to invovled

what I want to do is import info from a file (either txt or xls) the file will be sent to me from a website (via outlook 2010 and access 2010)

what I wanted to do is some how have Access check outlook folder for any new email (on a time schedule perhaps) and import the file automatically ...
Am I pushing my luck?

I can of course just pick up the file and drop in to a folder and import ...
- secondly i need to explain the import element ..
its insurance
Insured and property (buildings)
their can only be 1 Insured - but there could be x number of properties

my idea was to have the import element in to two parts
1 the insured (say sheet one of the xls)
2 the property (say sheet two of the xls )

so my import routine would be in two halfs (It will probably be more than this )
1 the insured - name - add etc and a indentifiy as a Prime Key
2and proeprty using the prime key of above

does that seem about right

G

 

[pbaldy]

I do a number of automated imports from emails. This is the code that got me started (the "saving an email attachment" code:

http://www.thatlldoit.com/Pages/howtosarticles.aspx

Once you have the file, you can work out the import. You can certainly grab the primary key of a new master record and use it for the child records.

 

[GaryPanic]

Cheers Paul
I had a quick look - way over my head -
but as long as it can be done .. If I need it , I can go down this route
and figure it out
If all I am getting (this is a pipeline project) is 1 or 2 files per day then its not going to be an issue - its if I suddenly got Volume files then I would have to re-think my approach (If I got Volume - probably better to get someone who knows what they are doing rather than some bogger (me) hacking around

Cheers

G

 

[pbaldy]

No problem. Post back if you dive in and get stuck.