Imported csv data - large No of fields in table

[mrkipling]

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

 

[namliam]

You can make the date and time field 1 field instead of 2 reducing it to 20 fields...

Then splitting will defenatly be bothersome.... And you should only start doing so if there is information there that shouldnt be.... eg. there may be 2 contact persons, you could normalize that into another table.
However if all fields are customer related, eg. address, zip, city, phone, fax, etc. you shouldnt split at all....

Regards

 

[mrkipling]

Thanks Namliam, As I thought, I couldnt see anyway to break the data down, as all data relates to that customer.

thanks again

Mark