Am developing a VB6 application in which an ACCESS table is linked using an ADODC. This all works fine.

The problem encountered is that our source data is in an EXCEL worksheet. We are using the MS Access import data routine to convert the EXCEL worksheet into an Access table. Sometimes this works fine, but sometimes for no immediately obvious reason the conversion routine will not copy any more than 14 fields across into an Access table. Additional fields come across as blank. When this happens, MS Access flags up that there has been an error, but does not assist by saying what it was.

The source EXCEL file worksheet has 27 columns and up to 1000 rows.

Thus this is not strictly a VB query but I am hoping that a VB6 forum member may have encountered a similar problem and be able to offer a suggestion.

Are different versions of EXCEL under which files are generated incompatible with different (earlier) versions of Access?

As an alternative (preferred not to be taken up) can anyone please point me to how to link an ADODC directly to an EXCEL worksheet rather than to an Access table.

camoore

Wales, UK