Skip to Content
avatar image
Former Member

.xlsx as a datasource

i have cr2011 version 14.0.2.364RTM

How do i select a .xlsx (excel 200) as an input data source ?

when i click:-

create new connection - access/excel(dao) /database type

i only see

excel3.0, excel4.0, excel5.0 excel 8.0

and none of these see .xlsx files when i click the database source (.....) button

I can export ok to .xlsx via "microsoft excel workbook data-only"

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 20, 2012 at 09:49 PM

    Hi John,

    You would need to create a 32-bit ODBC connection to the .xlsx file using the 'Microsoft Excel Driver (*.xls, *.xlsx, *.xslm, *.xlsb)'.

    Access/Excel(DAO) connection is not supported with .xlsx or .accdb.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded