Hi,
I have a small task, I need someone macro or vb code which or any other solution that does the job.
I have my MS Access database linked to an excel spread sheet and I need to query the spread sheet and insert the results into a MySql database table that the Access database is linked with.
If you look at the attached images you can see what I need. The [login to view URL] image is a screen shot of the query I put together which is linked to the excel spreadsheet and the [login to view URL] is the actual MySql table that I have Access linked to.
The MySql table has all the fields that are contained within the Access query but all items are contained within 1 record/row (order_id, active, sold, pending etc..) but the query returns 3 records.
I need to place the data from the 3 rows Access query into the single row of the MySQl table using the ordered field as the criteria.
Note that the Access query has a field named Status which returns Active, Pending and Sold values in the column, the field to the right of Status is named Total, I need to insert the values from the Total field into the MySql table in their corresponding fields (active, sold and pending)
I will also need to insert the Sold record from the Status Access query AvgOfSelling Price field into the MySql median field and the % Change field for the same record inserted into the MySql table %_change field.
I can supply you with the spread sheet an database when you need it.
My maximum budget is $50 USD.
Thank you for your interest!
Hi there,
We do this stuff all of the time, and can easily create a button linked to VBA code on a form that will do this for you and because we do this kind of thing a lot, it will only take about an hour or so (hence my low bid)
Please let me know if you wish to proceed and we can discuss my solution further.
Kind Regards & Best Wishes
Adam
Thanks for the opportunity to bid on your project. I will bring very strong Ms Access, Ms Excel and MySQL Software development experience to bear on your project should you elect to award the project to me.
I am available and ready to begin immediately.
I have around 6+ yrs of experience in MS Access, C#, .Net, MSSQL, MYSQL, SharePoint, Salesforce, PHP and ASP technologies. Please see my PMB for more details.
I have experience in SQL, VBA, and Access. I can definitely complete this project and satisfy the requirements as you have stated them. I look forward to working with you if awarded the project.
Hello, how are you?
I am 20 years expert in MS Access, an I have built a lot of applications, using Access, SQL and MySQL databases. I am sure I can do a good job for you.
With the MySQL database login, password and database name, I can easily do this job in 2 hours.
Please feel free to contact me.