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

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.

--