File Size

[Erictsang]

Dear all



I have a doubt, i am a new-commer for the Access

I try to import data from an excel which is around 1.4 MB but after imported , it turns to 2.4



is there anything i did wrong?



The above is the structure

[JoeM]

Access and Excel are different entities altogether, so the memory will not be the same.
Access has to create Table schemas, relationships, etc.

To keep the database size as small as possible, here are some things that may help:
- chosen the most efficient data-types for your table fields (i.e. don't use Long Integer or Double is something smaller will suffice, limit the size of text fields, etc)
- make sure that your tables are normalized so that you do not have a lot of blank fields in your tables (sometimes more tables is actually better)
- don't go too crazy and create too many unnecessary indexes
- run Compact & Repair occasionally to reduce database bloating