+ Reply to Thread
Results 1 to 2 of 2

real time data transfer from Excel to MySQL without using VB

  1. #1
    Registered User
    Join Date
    11-14-2010
    Location
    Karlsruhe, Germany
    MS-Off Ver
    Excel 2010, Excel 2007, Excel 2003, Excel XP, Exel 2000
    Posts
    1

    real time data transfer from Excel to MySQL without using VB

    Hi,
    I was wondering if it is possible to conect to MySQL database and transfer only the data in a cell (in Excel) to MySQL , without using VB script?

    Let me explain.

    I actually want to create a form in excel. The form will be connected to a MySQL database.
    I want to define a cell that shall take the input and send it to MySQL. I don't want to use any script. Is this possible????

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: real time data transfer from Excel to MySQL without using VB

    You might consider installing the XLOBDC.xla and trying to use SQL.REQUEST

    Post XL2002 this is not available by default - see: http://office.microsoft.com/en-us/ex...005209267.aspx for more info.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1