EXCEL - ACCESS hybrid without limitations

[kalos]

hello!

EXCEL has many limitations (eg 64,000 of rows max), ACCESS has other limitations, is there a hybrid, supporting VBA or other scripting/macro languages, without limitations?

thanks!

[x16wda]

As info, Excel 2007 allows a million rows and 16k columns.  But everything is going to have some limits.

[Ath]

What do you need this application to do?

[kalos]

What do you need this application to do?

-Ath (May 22, 2012, 05:21 AM)

I dont have something specific in mind, I just saw a video and got amazed of the EXCEL abilities, but unfortunately it has some bad limitations

[Ath]

but unfortunately it has some bad limitations

-kalos (May 22, 2012, 05:30 AM)

Hm, I've seen this video, but unfortunately my car also has some limitations. Maybe that'll be fixed if I'd buy a newer model?

[kalos]

but unfortunately it has some bad limitations

-kalos (May 22, 2012, 05:30 AM)

Hm, I've seen this video, but unfortunately my car also has some limitations. Maybe that'll be fixed if I'd buy a newer model?

-Ath (May 22, 2012, 05:52 AM)

if you gonna create a database, imo you should go with one that you wont stuck you in the middle, and realise the hard way that its limitations prevent you from implementing your goals!

[Shades]

@kalos:
Believe me, people/organizations that really require a database, do not consider Access. Too slow and bloated. Microsoft also offers (an Express version of) MS-SQL Server. the free version has a limit between 4 to 8 Gbyte if memory serves me right. Oracle also offers a free versions of their Database software (based either on their 10g or 11g version). Their limit is 4Gbyte.

Both databases are the real deal and waaaaaaay more interesting to play with then Access. Excel can work with both of these databases. Initially a bit more work to get your system running, but it scales a (whole) lot better.

Use PostgreSQL as open source alternative, which has a feature-set similar to Oracle database. As I am not that familiar with MS-SQL I cannot say if the PostgreSQL feature-set is also similar with that product.

[x16wda]

The current MS SQL Server Express has a 10gb per database limit.

As Shades suggests, free and open source alternatives abound.  PostgreSQL, Firebird, SQLite, MySQL are just a few.  They have different strengths and weaknesses but are very capable.

[Target]

Rather than asking for a generic solution to an as yet unknown problem, you'd be better served defining the problem before looking for an answer

Are these 'limitations' actually impacting what you want to do? and how - there might be a solution or work around)

It's worth remembering that while they might be 'similar', spreadsheets and databases are actually very different animals, and you wouldn't necessarily want to try and do things in one that you can do in the other.

That said, Excel and Access can and do work well together and share functionality (using VBA)