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
0
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.
 

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)
 

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)
 
Thread starter Similar threads Forum Replies Date
J Apps General Discussion 1
A Apps General Discussion 1
B Apps General Discussion 1
C Apps General Discussion 4
S Apps General Discussion 1
A Apps General Discussion 12
J Apps General Discussion 2
S Apps General Discussion 2
K Apps General Discussion 2
S Apps General Discussion 6
P Apps General Discussion 7
XAKEP Apps General Discussion 1
E Apps General Discussion 1
Y Apps General Discussion 1
C Apps General Discussion 1
S Apps General Discussion 5
THRobinson Apps General Discussion 1
P Apps General Discussion 1
I Apps General Discussion 9
R Apps General Discussion 0

ASK THE COMMUNITY