keepITcool wrote ...

I believe you must indicate that the driver should use headings,
else the column/field names are assigned as [F1]...[F256]

The implicit default value is

HDR=Yes

so column headings are assumed, as long as they are valid. 'Product'
isn't an a reserved word (ODBC nor Jet) and is valid.

I suggest you use the Jet engine.
For the correct connections strings see:
http://www.able-consulting.com/ADO_Conn.htm

You imply that using the ODBC provider is incorrect. I know of at
least one bug with the Jet provider which means for one of my apps I
legitimately choose to use the ODBC driver e.g.

http://support.microsoft.com/default...b;en-us;300948

Jamie.

--