Newbie on MS Access beg for info

[ntruong]

Hello Experts,

I've been using MS Excel to run the company pricelist (with several macros and macro to run auto-filtered quote). Now it grows so big that I run into the problem of maxing out the 4000 cell formats (there are 5 price lists in one single wb and we want them to look elegant).

Anyhow, is MS Access a better tool; if so, will I be able to import my excel pricelists to MS Access and keep all the formula, function, macros, calculation the same as they are now.

Many thanks in advance,
Nee

 

[BrianB]

The short answer is no.
There is no relationship between Excel and Access except for any links you make between the two. The VB macros are different in language and structure.

Personally I find Access useless for producing anything nice looking.
For my work I only use Access tables for anything above the Excel limit of 65,536 rows and link to an Excel workbook with a pivot table or whatever do do the reports.

4,000 rows is minimal for Excel. If you workbook is getting a bit large, try putting the table in a separate wb and link to that.