MySQL Forums - Microsoft Excel Forum for Microsoft Excel migration issues. http://forums.mysql.com/list.php?171 Mon, 27 May 2013 02:56:17 +0000 Phorum 5.2.19 http://forums.mysql.com/read.php?171,587229,587229#msg-587229 Link Excel 2013 to MySQL (1 reply) http://forums.mysql.com/read.php?171,587229,587229#msg-587229
I have a MySQL database in a server with some tables I'd like to download to an Excel 2013 spreadhseet.

I'd like this connection to be "live", that is, whenever the tables are updated in MySQL, the spreadsheet should be able to refresh the data.

I have installed MySQL Connector 6.6.5 and in Excel I go to "Data Explorer" , "Get External Data from MySQL", type in the host name and databse name and get the error:

DataSource.NotFound: MySQL: Unable to find a database provider with invariant name 'MySql.Data.MySqlClient'.
This error may have been the result of provider-specific client software being required but missing on this computer. To download client software for this provider, visit the following site and choose at minimum 'MySQL Connector/Net': http://go.microsoft.com/fwlink/?LinkId=278885 Details: null

I have installed the driver countless times and restarted my PC over and over, but I always get this error.

Thanks in advance for any help you can give me!]]> Nuno Nogueira Microsoft Excel Fri, 24 May 2013 11:56:47 +0000 http://forums.mysql.com/read.php?171,587136,587136#msg-587136 Now You Can Use Visual Studio 2012 To Work with Excel in .net and reporting services (no replies) http://forums.mysql.com/read.php?171,587136,587136#msg-587136 Visual Studio 2012.


• Developers can now use Visual Studio 2012 to work with Microsoft Word and other word processing formats from inside their own applications for creating, manipulating and converting documents independently of Microsoft Office Automation using Aspose.Words for .NET.

• They can also work with Microsoft Excel and other spreadsheet file formats in their own applications and can create, manipulate and convert documents without needing Microsoft Office Automation using Aspose.Cells for .NET. Aspose.Cells for .NET lets you automate reports and work with external data sources, create and export charts and work with formula.

• Developer can also work with Adobe Acrobat PDF files without relying on Adobe Automation. Aspose.Pdf for .NET lets you create and modify PDF files: concatenate or split files, add digital signatures, save pages to image format and more.

• Developers can now use Visual Studio 2012 to work with Microsoft PowerPoint and other presentation formats using Aspose.Slides.

• Developers can manipulate Microsoft Visio files using Aspose.Tasks.

• Developers can generate and recognize a large number of 1D and 2D barcodes using Aspose.BarCode.

• Developers can Work with Microsoft Outlook, from emails to contacts and appointments using Aspose.Email .

• Developers can Draw, manipulate and convert images using Aspose.Imaging.

• Recognize characters from entire images or specific areas using Aspose.OCR and many more advance features in their own applications.]]> zarfishan zahid Microsoft Excel Thu, 23 May 2013 08:19:03 +0000 http://forums.mysql.com/read.php?171,585596,585596#msg-585596 Installer not detecting Excel (3 replies) http://forums.mysql.com/read.php?171,585596,585596#msg-585596 Eric Strough Microsoft Excel Wed, 22 May 2013 13:45:23 +0000 http://forums.mysql.com/read.php?171,584926,584926#msg-584926 MySQL for Excel 1.1.1 (GA) has been released (1 reply) http://forums.mysql.com/read.php?171,584926,584926#msg-584926
MySQL for Excel enables you to directly work with a MySQL database from within Microsoft Excel so you can easily do tasks such as:
• Importing MySQL Data into Excel
• Exporting Excel data directly into MySQL to a new or existing table
• Editing MySQL data directly within Excel

You can download it from our official Downloads page at:
http://dev.mysql.com/downloads/installer/.


Version 1.1.1 is a maintenance release that contains the following bug fixes:

• Added code to check for changes on the contents of the currently selected Excel cells, so if the contents become empty the Export and Append data actions are disabled in the same way as they are disabled when a new cells selection is made and they contain no data. (Bug #16495151 - EXPORT TABLE LINK IS NOT DISABLED WHEN DATA IS DELETED)

• Added code to clear the format of a target Excel range where MySQL data is to be imported to before copying the values to the Excel range so the format applied to the Excel cells from a previous import operation does not corrupt the format of newly imported data. (Bug #16495155 - DATA GETS CORRUPTED WHEN CELL FORMAT IS DIFFERENT THAN DATA EXPORTED)

• Fixed logic that detects data types for columns to check for empty columns instead of excluded ones and properly assigning the default generic data type of varchar(255) to empty columns as per design. (Bug #16495493 - EXPORT DATA - DATA TYPE FOR EMPTY COLUMNS IS NOT AUTO-DETECTED)

• Fixed code that detected data types for columns for the scenario where only 1 row of Excel data is selected for Export or for Append, in which case the data type was always being set as a varchar(255) which is used when data types between rows are not consistent. (Bug #16493139 - AUTOMATIC MAPPING NOT WORKING)

• Added a parameter to the LoadConnections method that refreshes connections from its corresponding file, set to true when the the Refresh Connections action is performed. (Bug #16493129 - CONNECTION DETAILS NOT REFRESHED)

• Added code to prevent the connections, schemas and DB objects lists from drawing while they are being filled with items. (Bug #16392862 - CONNECTIONS LIST FLICKERS WHEN A CONNECTION IS DELETED OR ADDED)

• Added performance_schema to the list of system schemas, so now it shows along with the mysql and information_schema schemas list. (Bug #16473033 - PERFORMANCE_SCHEMA NOT LISTED UNDER "SYSTEM SCHEMAS" GROUP)

• Added code that converts numbers to invariant culture strings when building the SQL statements used to push queries to the MySQL Server. (MySql bug #67663, Bug #15903921 - USING MYSQL FOR EXCEL IN FRANCE)

• Removed code that always forced the FirstDisplayedScrollingColumnIndex of the preview grid to the currently selected column every time the First Row Contains Column Names checkbox is checked or unchecked. (Bug #16419402 - EXPORT DATA FREEZES WHEN SWITCHING HEADERS ROW)

• Set the CreateIndex property value in each new column to be exported immediately after the column data type's is auto-detected. (Bug #16238445 - EXPORT DATA - CREATE INDEX CHECKBOX IS NOT AUTO-CHECKED ON DATATYPE DETECTION)

• Moved logic that handles Table and Column values and warnings from Export Form (frontend) to MySQLDataTable and MySQLDataColumn classes (backend). (Bug #16397637 - EXPORT DATA - FOCUS GOES TO FIRST COLUMN WHEN EXCLUDING ANY OTHER COLUMN)

• Added code to expand each of the connection group nodes after they are initialized with existing connections. (Bug #16238782 - REMOTE CONNECTIONS SHOULD BE EXPANDED ON THE WELCOME PANEL)

• The context menu opened by right-clicking the preview grid in the Import Data Form is now showing context menu actions depending on the number of selected columns as follows:
o Select All: Visible when # of selected columns < total columns
o Select None: Visible when # of selected columns > 0
(Bug #16238663 - IMPORT DATA - CONTEXT MENU SHOULD SMARTLY SHOW SELECT ACTIONS)

• Removed the code that disabled the whole preview grid when the Import Form was used within an Edit Data operation, the disabling of the preview grid was disabling the horizontal scrollbar as well. Now the grid is not disabled but columns selection in the grid is cancelled when the Import Form is used by Edit Data which was the original intention since in Edit Data all columns must be imported to the worksheet. Disabled the context menu for the grid as well in this scenario. (Bug #16239011 - EDIT DATA - IMPORT DIALOG'S PREVIEW GRID HAS HORIZONTAL SCROLLBAR DISABLED)

• Added a link in the Welcome Panel to open an About box displaying the MySQLfor Excel version and copyright text. The About box can be closed by clicking on it or pressing the ESC key.(Bug #16238860 - MYSQL FOR EXCEL VERSION NOT VISIBLE UNLESS GOING TO ADD/REMOVE PROGRAMS)



You can access the MySQL for Excel documentation at:
http://dev.mysql.com/doc/refman/5.5/en/mysql-for-excel.html

You can find our team’s blog at:
http://blogs.oracle.com/MySQLOnWindows.

You can also post questions on our MySQL for Excel forum found at:
http://forums.mysql.com/.


Enjoy and thanks for the support!]]> Microsoft Excel Thu, 02 May 2013 18:39:20 +0000 http://forums.mysql.com/read.php?171,582281,582281#msg-582281 Opening Connection to MySQL Database from VBA (Excel) (1 reply) http://forums.mysql.com/read.php?171,582281,582281#msg-582281
I'm trying to connect to my Database using the following code found on the net. 


Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

As mentioned in the title of this topic I am using MySQL. If someone who is familiar with MySQL could please help me by telling me where to find 'myServerAddress' and 'myDataBase' within MySQL.

I am getting confused with the terminology as VBA and MySQL use different terminology for these. Is 'myDataBase' the name of the EER Model, and is 'myServerAddress' simply 'localhost' for a server running from the same machine as VBA?

Regards
Jordan]]> jordan elphick Microsoft Excel Wed, 03 Apr 2013 16:22:17 +0000 http://forums.mysql.com/read.php?171,581893,581893#msg-581893 Embeded Queries (no replies) http://forums.mysql.com/read.php?171,581893,581893#msg-581893 I have an Excel sheet that has around 40 embeded mysql queries, and each one produces a table that is determined by two dates. Currently, if the date range needs to be changed, I have to edit each query individually. What I want to do, if have the queries reference two cells in the Excel spreadsheet so that I can put in the 'TO DATE' in Cell A1 and the 'FROM DATE' in cell A2 and the query then references those fields.
Is this possible?
Thanks]]> Peter Riggs Microsoft Excel Wed, 20 Mar 2013 08:43:09 +0000 http://forums.mysql.com/read.php?171,581487,581487#msg-581487 MySQL for Excel timeout (3 replies) http://forums.mysql.com/read.php?171,581487,581487#msg-581487
Thanks.]]> James Haskell Microsoft Excel Wed, 03 Apr 2013 16:25:06 +0000 http://forums.mysql.com/read.php?171,581067,581067#msg-581067 MySQL for Excel 1.1.0 Connected but Excel document password protected (1 reply) http://forums.mysql.com/read.php?171,581067,581067#msg-581067
I've got around 25k plus entries in one of the tables and I want to bulk ammend some of the entries and then commit the changes, this is when the message arrives saying the document is password protected, the sort feature in excel is also disabled as you would expect with a protected document.

Here's my ploblem:

# The excel document that connects with MySQL is password protected and I didn't set it and don't have a password to unlock the document, I've tried all the associated passwords i know but non of them work so i guess it's being set by mysql or excel.
# although the document is protected i can alter individual fields and commit to MySQL successfully. I need to unlock the Excel document whilst connected to MySQL so I can make lots of changes as required.

Any help would be appreciated.
Craig

After much deliberation I think when Excel is connected to MySql it is actually MySql that's being viewed which is why the filters aren't working, if I copy the data from the connection to a new workbook all the filters are available.

With that in mind i should be able to log into the MySql control panel apply sort at the db end and then view and edit etc using Excel.]]> craig nelson Microsoft Excel Thu, 14 Mar 2013 03:36:44 +0000 http://forums.mysql.com/read.php?171,580652,580652#msg-580652 Could not connect to MySQL ODBC 5.1 (1 reply) http://forums.mysql.com/read.php?171,580652,580652#msg-580652
I have configured MySQL ODBC 5.1 on Linux Server but it gives me error as below when I try to connect:

isql -v test_mysql
[S1000][unixODBC][MySQL][ODBC 5.1 Driver]Unknown database 'test'

I have installed mysql-connector-odbc-5.1.11 for linux and configured odbc.ini as below:

[test_mysql]
Driver=/usr/lib64/libmyodbc5.so
Description=Connector/ODBC 5.1 Driver
SERVER=192.XXX.XXX.XX
PORT=3306
USER= ysql_user
Password=mysql_user
Database=test
OPTION = 3
SOCKET=/var/lib/mysql/mysql.sock

Please help me with this.

Regards,
Aparna.]]> Aparna Jonnavittula Microsoft Excel Fri, 08 Mar 2013 07:50:19 +0000 http://forums.mysql.com/read.php?171,579779,579779#msg-579779 connecting to mysql in excel with new release 5.2 (2 replies) http://forums.mysql.com/read.php?171,579779,579779#msg-579779
This is the code I used successfully before, I need a new DRIVER string for version 5.2. Any help appreciated

Public Sub ConnectDB(server As String, user As String, password As String, Optional Database As String, Optional testmode As Boolean)
On Error GoTo ErrHandler
Set oConn = New ADODB.Connection
oConn.Open "DRIVER={MySQL ODBC 5.1 Driver};" & _
"SERVER=" & server & ";" & _
"DATABASE=" & Database & ";" & _
"USER=" & user & ";" & _
"PASSWORD=" & password & ";" & _
"Option=3"


If testmode = True Then
MsgBox "Database Connection Test Successful!", vbInformation, "Success!"
'cmdInsertData.Enabled = True
End If
Exit Sub
ErrHandler:
MsgBox Err.Description, vbCritical, Err.Source
End Sub]]> thomas donino Microsoft Excel Fri, 15 Mar 2013 20:55:29 +0000 http://forums.mysql.com/read.php?171,576009,576009#msg-576009 How do you add together two cells in two different Microsoft Excel tables? (2 replies) http://forums.mysql.com/read.php?171,576009,576009#msg-576009

http://dermpurefacts.com]]> Emmak korter Microsoft Excel Wed, 27 Feb 2013 11:49:50 +0000 http://forums.mysql.com/read.php?171,575594,575594#msg-575594 How do you add together two cells in two different Microsoft Excel tables? (2 replies) http://forums.mysql.com/read.php?171,575594,575594#msg-575594
http://greencoffeecomplete.org/]]> Claren ompson Microsoft Excel Tue, 11 Dec 2012 17:21:39 +0000 http://forums.mysql.com/read.php?171,575543,575543#msg-575543 How To: Guide to Importing Data using MySQL for Excel (no replies) http://forums.mysql.com/read.php?171,575543,575543#msg-575543 - https://blogs.oracle.com/MySqlOnWindows/entry/introducing_mysql_for_excel
- https://blogs.oracle.com/MySqlOnWindows/entry/how_to_guide_to_importing]]> Edwin Desouza Microsoft Excel Fri, 07 Dec 2012 20:53:35 +0000 http://forums.mysql.com/read.php?171,575331,575331#msg-575331 EXEL to MySQL Server Connection (1 reply) http://forums.mysql.com/read.php?171,575331,575331#msg-575331 Jan Rynkiewicz Microsoft Excel Wed, 05 Dec 2012 20:04:38 +0000 http://forums.mysql.com/read.php?171,574014,574014#msg-574014 [Delete this post] Using MySQL for Excel in France (no replies) http://forums.mysql.com/read.php?171,574014,574014#msg-574014
Update the weblink on this page : http://www.mysql.fr/why-mysql/windows/
(forum link under "MySQL for Excel")]]> Tansu KAYRAK Microsoft Excel Sat, 17 Nov 2012 23:56:55 +0000 http://forums.mysql.com/read.php?171,573991,573991#msg-573991 Excel 2010 (1 reply) http://forums.mysql.com/read.php?171,573991,573991#msg-573991 Oleeizen john Microsoft Excel Tue, 04 Dec 2012 13:40:58 +0000 http://forums.mysql.com/read.php?171,573990,573990#msg-573990 Synchronize excel and mysql (1 reply) http://forums.mysql.com/read.php?171,573990,573990#msg-573990
I have an xls file that is changing every minute.
I would like to synchronize it in live with a DB mysql

Is it possible ?

Thx

Stéphane]]> Stephane Messika Microsoft Excel Fri, 07 Dec 2012 21:57:03 +0000 http://forums.mysql.com/read.php?171,573810,573810#msg-573810 Excel bamboozelry (1 reply) http://forums.mysql.com/read.php?171,573810,573810#msg-573810
The low-down:

CSV file database export with category names from my ecommerce site.

column 1 (Name) column 2 (ID)
super soakers 153
shoes 188
bottles 297

CSV file import file

column 1 (ID) column 2 (product name)
super soakers Big Super Soaker
shoes Black shoe with no laces
bottles Jim Beam Bottle

The need:
I need for file 2 (the import file) to know and change the value of column 1 to be the value of column 1 in the file 1 (export file) so that the 5k products that I have with over 200 categories can be done in one quick swoop.

ideas?

I'm willing to create random columns with the column 1 and 2 from file 1 into file 2 just so I dont have to search in other sheets or files.

The outcome (import):
column 1 (ID) column 2 (product name)
153 Big Super Soaker
188 Black shoe with no laces
279 Jim Beam Bottle]]> Matthew Jaramillo Microsoft Excel Fri, 07 Dec 2012 22:03:44 +0000 http://forums.mysql.com/read.php?171,573694,573694#msg-573694 Introducing MySQL for Excel (no replies) http://forums.mysql.com/read.php?171,573694,573694#msg-573694 https://blogs.oracle.com/MySqlOnWindows/entry/introducing_mysql_for_excel
- http://mysqlblog.fivefarmers.com/2012/11/08/using-mysql-for-excel/]]> Edwin Desouza Microsoft Excel Tue, 13 Nov 2012 18:24:42 +0000 http://forums.mysql.com/read.php?171,573311,573311#msg-573311 Using MySQL for Excel (no replies) http://forums.mysql.com/read.php?171,573311,573311#msg-573311 http://mysqlblog.fivefarmers.com/2012/11/08/using-mysql-for-excel/]]> Edwin Desouza Microsoft Excel Fri, 09 Nov 2012 04:21:40 +0000 http://forums.mysql.com/read.php?171,572433,572433#msg-572433 Insert Data in Table from Excel sheet (5 replies) http://forums.mysql.com/read.php?171,572433,572433#msg-572433
I have simple question. Is there a way that I can insert data in table from Excel sheet?
If yes, how?

Thanks,

TA]]> TA GHA Microsoft Excel Tue, 01 Jan 2013 16:02:46 +0000 http://forums.mysql.com/read.php?171,571501,571501#msg-571501 Excel like formulas in MySQL (1 reply) http://forums.mysql.com/read.php?171,571501,571501#msg-571501
imagine a Excel spreadsheet like this:

. A. . . B . . . . . . . . . . . . . . . . . . . . . .
1 xyz "=IF(ISERROR(SEARCH("xyz",$A1,1)),0,1)"
.
2
.
.
.

Is this somehow possible to implement in MySQL?
The reason why I am trying to this with MySQL is because Excel is too slow/instable with 200k+ rows and 20+ columns.

Thanks in advance and have a nice evening.]]> Stefan Hubert Microsoft Excel Fri, 07 Dec 2012 22:40:17 +0000 http://forums.mysql.com/read.php?171,570217,570217#msg-570217 another newbie question: "unspecified error" in ODBC (2 replies) http://forums.mysql.com/read.php?171,570217,570217#msg-570217 now i am trying to connect from excel, using the data connection wizard
i click on ODBC DSN, and I am shown the one i just created.
there i tick the radio button "Use data source name", and from the menu choose the right one, and i enter the user name and password.
Alas when i press "Test Connection" I get

"Test connection failed because of an error in initializing provider. Unspecified error"

any help much appreciated

PS: I have the MySQL for Excel also in - does it conflict?]]> Alberto Cherubini Microsoft Excel Fri, 07 Dec 2012 21:49:01 +0000 http://forums.mysql.com/read.php?171,570204,570204#msg-570204 help for newbie (6 replies) http://forums.mysql.com/read.php?171,570204,570204#msg-570204 I have managed to connect, and I see the standard sakila database etc.
But following the documentation I see it mentions a butto "Edit MySQL Data" which I do not have - I have only Import MySQL Data.
Also it shows a grey box with MySQL for Excel, AutoCommit,Revert Data, Commit Changes
which I do not have.
If I press "import MySQL Data" I get hard coded data, not a real connection, so I cannot refresh it if I edit it...

Clearly I must have done something wrong, hopefully just a configuration flag somewhere?

Looking forward to your help]]> Alberto Cherubini Microsoft Excel Tue, 15 Jan 2013 06:24:23 +0000 http://forums.mysql.com/read.php?171,569908,569908#msg-569908 how to insert Hindi excel data into MySQL database in Hindi Language (2 replies) http://forums.mysql.com/read.php?171,569908,569908#msg-569908 FileNumber
13@e 1&100@98 (this is in Hindi format)
Now I want to insert this data into mysql database when I done it, it is loading as looking as it is but i want to insert this with Hindi which I need to print for Client. I have used mysql cmd to load the data.]]> chakravarthy l Microsoft Excel Fri, 07 Dec 2012 23:31:41 +0000 http://forums.mysql.com/read.php?171,568907,568907#msg-568907 How do I have Excel export fields encapsulated by double-quotes (3 replies) http://forums.mysql.com/read.php?171,568907,568907#msg-568907
I need Excel to surround all fields with double quotes, and then deliminiate each field with a comma. The only fields I don't need encapsulated in double-quotes are numeric fields.



Example (I need the following):
"JSMITH","John","Smith",1

Instead of:
JSMITH,JOHN,SMITH,1



How can I do this?

Some of my spreadsheets I'm trying to export have 300+ rows, and that can be very time consumuing to manuall add double-quotes to each field in an exported file.]]> Chris Bassett Microsoft Excel Fri, 07 Dec 2012 22:20:37 +0000 http://forums.mysql.com/read.php?171,567823,567823#msg-567823 Connect MySQL to an Excel Spreadsheet (6 replies) http://forums.mysql.com/read.php?171,567823,567823#msg-567823
It's a fairly complicated spreadsheet with a lot of formulas and fields.

I followed a couple tutorials on connecting it to MySQL using ODBC and the MySQL server, but it fails every time.

Do I need to create a MySQL database that matches all the fields on the spreadsheet?

I'm trying to avoid having to re-create the Excel spreadsheet in another program. I just want to use it as a front end. Any thoughts on how I might accomplish this?

Thank you in advance.]]> M Von Heinrich Microsoft Excel Tue, 12 Feb 2013 23:05:24 +0000 http://forums.mysql.com/read.php?171,563916,563916#msg-563916 Excel Jams when connecting!! (no replies) http://forums.mysql.com/read.php?171,563916,563916#msg-563916
I have a system VBA based that uses an MySQL Database. I have a lot of forms (ActiveX) that selects columns, data, dates, etc. to fill a table that in the end will become a accountability report.

The problem: This spreadsheet often jams and crashes Excel without showing any debug problem. Goes straight to "Send report to Microsoft". I know that it occurs sometime when run a macro that updates all queries in the workbook.

Does anyone had any problem like this? I just can't find out why sometimes it crashes my excel and sometimes don't, works completely ok!

I suspect it could be a physical network problem (PC - server), but if it was it, how would it work sometimes? I thought also that maybe this machine isn't powerful enough, but again, a Pentium 4 3gh 2gb ram shouldn't crash like this. Isn't the best one, but far from the worst I worked on.

any ideas? please, help me!!

thanks!!

Just for record, I use codes like this ones:]]> Luiz De Rose Microsoft Excel Fri, 03 Aug 2012 21:46:59 +0000 http://forums.mysql.com/read.php?171,561930,561930#msg-561930 Microsoft Excel and MySQL: Articles, Blogs (no replies) http://forums.mysql.com/read.php?171,561930,561930#msg-561930 - Docs: http://dev.mysql.com/doc/mysql/en/mysql-for-excel.html
- Forum: http://forums.mysql.com/posting.php?171
- https://blogs.oracle.com/MySqlOnWindows/entry/introducing_mysql_for_excel
- https://blogs.oracle.com/MySqlOnWindows/entry/how_to_guide_to_importing
- http://mysqlblog.fivefarmers.com/2012/11/08/using-mysql-for-excel/

http://net.tutsplus.com/tutorials/php/how-to-generate-a-complete-excel-spreadsheet-from-mysql/


http://helpdeskgeek.com/office-tips/excel-to-mysql/
http://blog.tjitjing.com/index.php/2008/02/import-excel-data-into-mysql-in-5-easy.html
http://blog.mclaughlinsoftware.com/microsoft-excel/accessing-to-mysql/


Apple Mac OS:
http://blog.mclaughlinsoftware.com/2011/02/27/excel-2011-query-mysql/
http://blog.mclaughlinsoftware.com/microsoft-excel/excel-2011-mysql-config/
http://blog.mclaughlinsoftware.com/2011/02/10/mac-os-x-mysql-install/
http://blog.mclaughlinsoftware.com/mysql-databas/mysql-connector-odbc/


Python and Excel:
http://packages.python.org/openpyxl/
http://scienceoss.com/read-excel-files-from-python/
http://scienceoss.com/write-excel-files-with-python-using-xlwt/
http://www.python-excel.org/
http://pytools.codeplex.com/wikipage?title=Pyvot
http://packages.python.org/Pyvot/
http://pypi.python.org/pypi/Pyvot
http://pyxll.com/
https://datanitro.com/


PHP and Excel:
https://github.com/PHPOffice/PHPExcel



Excel-to-Database
http://leansoftware.net/en-us/products/exceltodatabase.aspx]]> Edwin Desouza Microsoft Excel Wed, 18 Jul 2012 20:21:37 +0000 http://forums.mysql.com/read.php?171,557984,557984#msg-557984 last_insert_id and VBA Excel (1 reply) http://forums.mysql.com/read.php?171,557984,557984#msg-557984
I then need to get the PK of the record I just inserted and put that value into a cell on the spreadsheet.

So my SQL statements are something like

INSERT INTO myTable (field1,field2) VALUES (value1,value2);
SELECT last_insert_id;

Could somebody please provide some VBA code that could be used to execute the second statement and store it someplace that I can use with
CELLS(row,column).value = the new PK.

Thanks to all...........Rich]]> Richard Pupko Microsoft Excel Mon, 18 Jun 2012 22:46:12 +0000