Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to import SQL databases automatically / by batch?
Hi,
I have 20-30 SQL database files. How can I to import the data into Excel files automatically or by batch (using macros)? Thanks Simon |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to import SQL databases automatically / by batch?
There are a few method. The easiest to set up is to perform a query fro the
worksheet menu Data - Import External Data - New Databae Query. the second metho is to use a macro to open the database a retrieve the data using SQL. You can actually get the SQL statements by recording a macro when you do an New Database Query. If you record the macro while performing a New Database query the Command Text portion of the recorded macro is the SQL statments. If yo need help record the macro and post the rrecorded macro for additional assitance. "Simon Kwong" wrote: Hi, I have 20-30 SQL database files. How can I to import the data into Excel files automatically or by batch (using macros)? Thanks Simon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Access Data from 3 databases into 1 worksheet *ERROR* | Excel Discussion (Misc queries) | |||
Macro to automatically fill and submit (in batch) an online form fromdata in a excel sheet??? | Excel Discussion (Misc queries) | |||
Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) | |||
batch import dat files | Excel Discussion (Misc queries) | |||
Import from corporate databases | Excel Discussion (Misc queries) |