Examples of Using VBA, ODBC, and mysql

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: bwreath (bwreath.17woyy_at_excelforum-nospam.com)
Date: 06/15/04 

Date: Tue, 15 Jun 2004 14:10:12 -0500

Hi,

I would appreciate very much if someone could provide
some examples on how I can capture, manipulate the
data once I have made a connection to a mysql database
from Excel using VBA using ODBC.

I used a macro recorder and I have made a successful
connection to my database but I am not really that familiar
with how to manipulate the data.

Right now I have the data going to the cell A1 in my worksheet.

I am interested in capturing the data into a variable or an array
and then subsequently feeding the result select statement into
another sql statement.
I think it would really help if someone could provide some examples of
data manipulation after the connection.

thanks! 

---
Message posted from http://www.ExcelForum.com/

Relevant Pages

  • Re: Firewire Questions
    ... so I only need to make the connection. ... That's not a direct capture. ... Is that the RAW DV footage? ... (well over 1 GIG for each minute of video) ...
    (rec.video.desktop)
  • Re: Was wondering if there was ever a solution to this problem.
    ... If you find your CA root certificate is expired and you should deleted! ... A network capture shows that after a SSL connection is established, ... to the client for the first time. ... I don't have a network capture of that yet. ...
    (microsoft.public.exchange.admin)
  • Re: Wireless Sniffing in Windows 7 with Netmon 3.4
    ... If you sniff and get nothing, ... The first is a capture from an 802.11b AP done November 23rd last year. ... connection. ... There are malformed packets in both .cap files. ...
    (alt.internet.wireless)
  • Windows Movie Maker message
    ... I have windows XP home edition on my COMPAQ PRESARIO 2195 labtop. ... 15-28 minutes of a complete concert.I have tried the manuel capture option[ ... which gave me 28 minutes] and the capture whole video option[which gave me ... connection going into my computer or the connection going into my ...
    (microsoft.public.windowsxp.moviemaker)
  • Re: Video Capture Devices in MCE - Composite and Tuner??
    ... Works great with firewire connection from Sony camcorder. ... How can I install drivers if Windows does not see the device? ... I just got a Sony Vaio PC with MCE. ... How do I capture from composite in MCE? ...
    (microsoft.public.windows.mediacenter)