Excel 2007 data file

[Former Member]

I am not able to create a new conection with a file saved in excel 2007 (*.xlsx) does anyone know why??

[former_member292966 · Accepted solution]

Hi,

What version of Crystal are you using?

What method are you using to connect to your Excel spreadsheet (ODBC or just opening the xlsx file)?

What errors do you get when you try opening the spreadsheet?

This should work. I have Crystal XI and I can open a xlsx file with no problems.

Thanks,

Brian

[Former Member · Accepted solution]

Hi Brian,

I use Crystal XI, what I do to conect to my database is just click on "creat a new conection" and click on "access/excel (DAO)" then browse to pick my file, It has been working with no problems but I just changed my excel version from 2003 to 2007, and It is giving me the following error

LOGON FAILED.

DETAILS : DAO ERROR CODE 0xcca.

SOURCE :DAO Workspace.

DESCRIPTION : EXTERNAL TABLE IS NOT IN THE EXPECTED FORMAT"

Thanks so much for taking the time to try to help me

Nela

[former_member11696 · Accepted solution]

Hi Nela,

Is this happening with a new report or are you using old reports connecting to Excel 2007 files?

It may be that you need to do a set location and then Verify Database to update the connection info.

Thank you

Don

[Former Member · Accepted solution]

Hello Don

This is hapenning with a new report.

How do I set a new location??

Thanks

Nela

[Former Member · Accepted solution]

Hi,

A CSV isn't the same as Excel format, it should error. You can import the file

into Excel first and then use it, or you can set an ODBC connection to the CSV file

Thanks,

Sridhar

[Former Member]

I am having the same problem trying to Create a new connection to and xlsx file. Was this resolved?

Thanks,

Paul

[former_member11696]

Current versions of CR do NOT support xlsx file types, next one will. No option other than using ODBC or some bridge between that file type.

Thank you

Don