Solved ado mysql

Posted on 2011-05-06
Last Modified: 2013-11-27
currently got working code for send data to a csv
Public outfile
Private Sub csv_handler()
        Dim csv_out_string As String
        ''''''''outfile at 5min intervals
        csv_out_string = String.Format("{0:g},{1:00.00},{2:00.00},{3:00.00}", DateTime.Now, x1, x2, x3)
    End Sub

Now I want to write that to a mysql database table using and express edition

please help
Question by:IanTh
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    well, the only issue you need to ensure is that for MySQL, the datetime must be in format 'YYYY-MM-DD' and with time 'YYYY-MM-DD HH:MI:SS'
    LVL 30

    Author Comment

    but what code do I use I am fairly familiar with mysql dataset and tables from a web design perspective but not from so I need to know how to connect and update the data first

    I do have a timer setup for 5 mins if thats relevant
    LVL 142

    Accepted Solution

    LVL 30

    Author Comment

    that mentions 2005 not 2008 will it still work I thought It had to use too
    LVL 142

    Assisted Solution

    by:Guy Hengel [angelIII / a3] will also work in vs 2008
    LVL 30

    Author Closing Comment

    abandoned going c# on linux via mono

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Both Easy and Powerful How easy is PHP? (  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now