Using Excel as the database

[mfiguei]

Hello
I am trying to use an excel spreadsheet as my database. when I do so I get a message "Excel Driver Login Failed. Could not decrypt file".

What do I need to do? and how?

any help would be most appreciated.
Mark

 

[synapsevampire]

The file is probably password protected.

-k

 

[SurfingGecko]

Another approach you may want to try is creating a report using the Crystal Reports Excel Add-in.

Depending on your version of CR you should see a toolbar for it. If not you coudl add it from the Tools > Add-ins menu.

With this you could choose the cells you want to report on.

Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease

 

[mfiguei]

Thanks Guys.
It turns out the workbook was password protected. I had unprotected the worksheet but it wanted the whole workbook unprotected.

Anyway, that second option, "Excel Add-in", has opened up a new world for me. I didnt realize that feature was there.

Thanks you so much!
Mark

 

[SurfingGecko]

You're most welcome ;-)

Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease