Creating reports and dashboards | Stimulsoft community forum

Is there a data adapter available for Excel? In my list of data connection types I see one for access but nothing for Excel. I know there are ODBC drivers available for Excel but I wanted to see if there is a recommended data adapter to use with Excel files.

Hello.

jmiller wrote:Is there a data adapter available for Excel? In my list of data connection types I see one for access but nothing for Excel. I know there are ODBC drivers available for Excel but I wanted to see if there is a recommended data adapter to use with Excel files.

Please, try to use OleDB. See the sample report in attachment.

Thank you.

Thanks for the info. I will give it a try.

I am running into a problem. I have a 64-bit machine but the OldDB driver seems to only work in 32-bit. Ideally, I would prefer to continue to run Stimulsoft in 64-bit. Do any of your data adapters access Excel and works in 64-bit?

Hello.

jmiller wrote:I am running into a problem. I have a 64-bit machine but the OldDB driver seems to only work in 32-bit. Ideally, I would prefer to continue to run Stimulsoft in 64-bit. Do any of your data adapters access Excel and works in 64-bit?

Unfortunately we haven't Excel data adapters. Please, try to download 64-bit OleDB drivers from Microsoft site.

Thank you.

Thanks. I was able to get my IT people to download the appropriate driver and all works fine.

Excellent!

Hello, xiami.

thx for the info, i have the same problem

Is your problem solved now?

Thank you.

As far as I go, my problem has been solved with the proper driver installation. Thanks for your help.

Hello,

Great! :biggrin: