How to execute an SQL insert/update from Excel for Mac

L

Laphan

Hi All

I know this might be predominately a Win NG, but I'm hoping you had a Mac at
some time in your life!!!

Basically I can use VBA/Macro to select and put the result data into a
worksheet no probs, but I have no idea how I post data (ie insert, update or
preferably send data to a stored proc).

My spec is I have 1 x Mac OS 9 clean and 1 x Mac OS 9 Classic connecting to
a Win2000 Server running SQL Server 2000. The client app is Excel 98 and
Excel 2001 and both are using the Merant ODBC 3.5.1 drivers that MS made
available on their web site when they forgot to include them on the Excel
2001 CD.

Can you help?

All I need is a simple VBA code snippet to show me how I do it.

Thanks

Laphan
 
T

Tom Ogilvy

news://msnews.microsoft.com/microsoft.public.mac.office.excel

Might be a good place to ask as well.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mac Excel 2008 question 1
import data from excel under Mac OS 1
lock out menus? 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel 2007 in Mac or Excel 2008 for Mac? 1
How to Recover files from Emptied Trash on Mac OS X? 8
VBA on Excel 2004 Mac 3
How to use Excel VBA program to execute SQL SERVER stored procedur 2

Top