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????
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.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks