Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 Macro to Execute SQL Statement
Hi, I'm trying to write a macro in Excel 2002 to execute
the following (example) SQL statement: insert into `C:\Documents and Settings\User\Desktop\Test`.`Master$` (Apples, Pears, Oranges,Store) SELECT `Update$`.Apples, `Update$`.Pears, `Update$`.Oranges, `Update$`.Store FROM `C:\Documents and Settings\User\Desktop\Test`.`Update$` `Update$` The macro would run from inside the test.xls spreadsheet which has already been defined as an ODBC Data Source. I know that the SQL statements are correct, because I can manually enter them into MS Query from inside Excel and get the desired result. I've tried reading the MS Visual Basic help for this, but it's far above my expertise. Any clues/suggestions would be much appreciated. Thanks, David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I execute a macro based on the value of a cell in Excel? | Excel Discussion (Misc queries) | |||
If Statement on Excel version 2002 | Excel Discussion (Misc queries) | |||
Execute Excel Macro using Java | Excel Programming | |||
access 97 to excel 97: execute macro automation | Excel Programming | |||
access 97 to excel 97: execute macro automation | Excel Programming |