| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data import odbc
Hi,
I have imported data with a macro in excel from odbc as 400 and it's ok. But is possible group them like in a normal sql data transfer? In fact if grouped the number of records imported in excel is considerably lower. I have tried but without success. Is a syntax problem or this feature is not supported? Thanks a lot |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data import odbc
"AleP" wrote ...
I have imported data with a macro in excel from odbc as 400 and it's ok. But is possible group them like in a normal sql data transfer? In fact if grouped the number of records imported in excel is considerably lower. I have tried but without success. Is a syntax problem or this feature is not supported? You can use the Microsoft OLE DB Provider for Jet to query a text file: http://support.microsoft.com/default...NoWebContent=3 The Jet engine supports the GROUP BY syntax: http://msdn.microsoft.com/library/de.../D2/S5A326.asp Jamie. -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
| ODBC Driver/Import Data | Excel Discussion (Misc queries) | |||
| Get SQL data to Excel without ODBC | Excel Programming | |||
| ODBC import screws up fx | Excel Programming | |||
| Importing ODBC Data .. anywhere?? | Excel Programming | |||
Linear Mode
