Excel Data Adapter ?

jmiller · Post by **jmiller** » Thu Aug 25, 2011 9:39 am

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.

Post by **HighAley** » Fri Aug 26, 2011 1:38 am

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.

jmiller · Post by **jmiller** » Fri Aug 26, 2011 4:48 am

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

jmiller · Post by **jmiller** » Fri Aug 26, 2011 5:34 am

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?

Post by **HighAley** » Fri Aug 26, 2011 7:54 am

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.

jmiller · Post by **jmiller** » Wed Aug 31, 2011 7:17 am

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

Post by **Andrew** » Wed Aug 31, 2011 10:52 pm

Excellent!

Post by **Andrew** » Thu Sep 01, 2011 7:21 am

Hello, xiami.

thx for the info, i have the same problem

Is your problem solved now?

Thank you.

jmiller · Post by **jmiller** » Wed Sep 07, 2011 3:14 pm

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

Post by **Andrew** » Wed Sep 07, 2011 10:00 pm

Hello,

Great! :biggrin: