Newbie on MS Access beg for info

ntruong

Active Member
Joined
Aug 4, 2003
Messages
261
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
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,518
Messages
5,596,622
Members
414,082
Latest member
sasmita

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top