Data import odbc

A

AleP

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
 
J

Jamie Collins

...
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?
Click to expand...

You can use the Microsoft OLE DB Provider for Jet to query a text
file:

http://support.microsoft.com/defaul...port/kb/articles/q262/5/37.asp&NoWebContent=3

The Jet engine supports the GROUP BY syntax:

http://msdn.microsoft.com/library/d...y/en-us/office97/html/output/F1/D2/S5A326.asp

Jamie.

--
 
Top