i have imported my data into acces but i am still having difficulty to apend this reords into exting tables in my access datab

uty

Estimable
Apr 3, 2014
1
0
4,510
I have a lot of data in excel and its coming to point where I cant easily report so I am trying import this data into access which can be easier to manage. where I can easily generate weekly, monthly, quarterly and yearly reports.
 
Solution
1. Moving this to 'Applications'

2. Assuming a recent version of Access/Excel, Import. This creates an internal table in Access. You can then generate whatever 'reports' you need. Or append to whatever tables you need.

3. Once you give up the Excel interface, you'll have to create an Access Form interface for people to enter the data. (Non-trivial)

USAFRet

Illustrious
Moderator
1. Moving this to 'Applications'

2. Assuming a recent version of Access/Excel, Import. This creates an internal table in Access. You can then generate whatever 'reports' you need. Or append to whatever tables you need.

3. Once you give up the Excel interface, you'll have to create an Access Form interface for people to enter the data. (Non-trivial)
 
Solution