Hi,

I have a problem reading the first line of a Excel table
opened out of VB 5.0.

set DB = MyWork.Opendatabase(Path,True,True,"Excel 5.0;")
set RS = MDB.OpenRecordset("SELECT * FROM Table1", dbOpenDynaset)

I can now move through the whole resultset to get all rows in the
spreadsheet. But I am still not able to read to first row, even after
using a rs.movefirst.

Anyone else had these problems too? Any hints?

Zhanxs in advance.

Marcel

When you read a range as a table DAO uses the first row of cells in the
range as the field names, therefore you need to put something like this to
access the first field :

X = rs(0).Name

Hope this helps

Keith Duncan
Datagen Consultants Ltd.

[This followup was posted to comp.lang.basic.visual.misc and a copy was
sent to the cited author.]

I thought about this too, but there is another problem: If the first row
doesn't contain valid DAO field names it assigns his own fieldnames.
For example: If it contains a number (20095), the field name is
afterwards 'F6'.

Anyone knows how it was solved in Access? With OLE?

Zhanxs in advance.

Marcel