excel and access

[Lino]

Currently i am using excel to do create my database but i am finding that i am running out of columns. I am not too familiar with access...does the column limitation aspect exist in access and will the macros that i created for excel work in access. These macros consist of addition,multiply,standard deviation,named ranges.

thanks,

lino

 

[Joe4]

I know Access has a lot fewer limitations on size of rows, I am not sure about columns though. I don't know anything about your database, but most of the time, a well designed database should not have an exorbitant number of columns. In Access, you usually have multiple tables and the tables are linked together.

Your VBA functions *should* transfer over, but may have to be manipulated a little. The language in Access VBA is very similar to Excel VBA, but there are some differences.

 

[CT Witter]

If you look under Access Help with the keyword limits or Access specifications you should get the specifications. Here is the one for Tables:

Attribute Maximum
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table 255
Number of open tables 2048; the actual number may be less because of tables opened internally by Microsoft Access
Table size 2 gigabyte minus the space needed for the system objects
Number of characters in a Text field 255
Number of characters in a Memo field 65,535 when entering data through the user interface;
1 gigabyte of character storage when entering data programmatically
Size of an OLE Object field 1 gigabyte
Number of indexes in a table 32
Number of fields in an index 10
Number of characters in a validation message 255
Number of characters in a validation rule 2,048
Number of characters in a table or field description 255
Number of characters in a record (excluding Memo and OLE Object fields) 2,000
Number of characters in a field property setting 255