Importing into access from a webform suggestions needed

[kingdoz]

Hi Guys,

I have written a nice small access database but im banging my head against a wall wondering what I should do next and how to do it.

I run a small company and clients submit order details online through my PHP website. This currently comes to me as a simple email with fields filled in, including both client details and the order details.

What I am finding is that I have to copy and paste all fields into the database daily and it is a big chore.

My webdesigner told me he can send the email data in CSV format rather than text format so I can copy/paste much faster directly into the Access Table. However there are 3 problems with this.

1. A client fills in the data. I would then have to see if he is a new client and this is his first order. If he is new, I have to populate the "clients table" first with the first few fields filled in from the order form which lists the client details, and then I have to fill in the "orders" table with the order.

2. If he is a current client, then I only have to populate just the order table but I need to make sure its connected to the correct client of course. As my database generates the client ID (not the website) I dont know the best way for this.

3. I would rather have a button in Access or in Outlook to "automatically import all this data" rather than have to copy and paste from the CSV everytime.

Any help will be appreciated. I am also happy to pay for some work if need be (if I cant do it myself or if lots of VBA work as I mainly work in Macros).

Thanks
Doz

 

[pbaldy]

Welcome to the site. I'm sure what you want can be accomplished. I created an automated process awhile back that automatically imports Excel files in emails into Access (actually SQL Server, but the same process would work for Access). Search on automation, as it's the way you would control Outlook from Access (it could probably be done from Outlook, but I'm more comfortable from the Access side). I've got to go help a user, so see if that gets you going in the right direction. It would be a VBA solution; I'm not sure you can use macros to go across platforms.