Try http://www.jobstats.co.uk/[^] for computing employment data Hope it helps

You might want to try and use Oracle Sequence (similar to SQL seeded Identifier)

Actually MDAC 2.6 and later do not contain Jet drivers any more See link[^]

e.g BSTR bstrValue _bstr_t bstrTemp(bstrValue); CString sValue = (LPCTSTR)bstrTemp;

I recently created a composite control using pure ATL and WTL (No MFC) and I had no problems. You might need to give me more details on what goes wrong ?

try http://www.codeproject.com/useritems/atloutlookbar.asp[^] ;)

I would be careful on how you use the recordcount method. I think this is just a water mark of the number of records you have iterated through. The count that it returns is only correct if you have iterated through the whole recordset. You have to use EOF and BOF to work out if you have any records. When you Import the ADO object you usually rename EOF to what ever you want

or you can do this CString t = "Hello" "World"; without the '\' slash character

You need to create an ATL Project from the main wizard, then add the composite control from the 'Add ATL Object' Wizard. This gives you the basic composition control that you can use in VB. Professional ATL COM Programming by Richard Grimes has a good chapter on this suject.

don't forget http://www.viksoe.dk/wtl/

Sorry Tom But Nigeria can not qualify, they are all ready out Its either Argentina, Sweden or England I say it will be Sweden and England

That third parameter on your Execute call looks dodgy, I think it should be something like adNoOptionSpecified (it might be slightly spelt incorrectly, check MSDN)

See following article - http://www.codeproject.com/docking/toolbar\_hotbuttons.asp

Get the Freeware client application called TOAD. Its the best equivalent to SQL Enterprise Manager, but for Oracle. From http://www.toadsoft.com/ You wont regret it.

See sample app of COM Variant and Safearrays at http://www.sellsbrothers.com/tools/CComSafeArray.zip It also uses VB Clients and C++ COM Object Best SafeArray Sample that I have seen (from chris sells site) :cool:

Check this out on Sky News http://www.sky.com/skynews/article/0,,30000-1046315,00.html

See sample app of COM Variant and Safearrays at http://www.sellsbrothers.com/tools/CComSafeArray.zip (from chris sells site)

See my sample on MS Data Grid, That Auto fills data for you. http://www.codeproject.com/useritems/msdatagrid.asp MS Data Flex Grid is used with ODBC and non OLE DB data sources. MS Data Grid is used for OLE DB data sources.

This sample uses the MS FlexGrid http://www.codeproject.com/database/isqlado.asp

This problem is usually related to the fact that you don't have an index for the table, but as you are using excel, I am not sure !!