I currently have an access database that imports csv's via the importspec and vba into a table. These csv's hold info on customer details and contain 18 fields for each customer record. I have also added to this table an auto date and time field and an autonumber customer ID field.
I am now thinking that this table is getting rather large as it now contains 21 fields, should I think about splitting this table down into smaller tables ?
All the customer information is archived to another table once a week, and there is a form that allows manual input customer details as well.
Can somone advise me as to how would be best to manage this data, as I feel that splitting it into smaller table will provide headaches when it comes to managing the data.
any input appreciated.
TIA.
Mark
I am now thinking that this table is getting rather large as it now contains 21 fields, should I think about splitting this table down into smaller tables ?
All the customer information is archived to another table once a week, and there is a form that allows manual input customer details as well.
Can somone advise me as to how would be best to manage this data, as I feel that splitting it into smaller table will provide headaches when it comes to managing the data.
any input appreciated.
TIA.
Mark