Click here to Skip to main content
15,884,836 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I want to import the data from excel to access table line by line.
for example user click on a button in access form and it insert rows,
if rows was incomplete or mismatch with data type shows a report..
any sample?
now the form is in Ms Access
Posted
Updated 8-Apr-12 0:04am
v3

Have a look at this: Converting an Excel Spreadsheet to an Access 2007 Database[^]

Best regards
Espen Harlinn
 
Share this answer
 
Comments
Abhinav S 9-Apr-12 3:39am    
My 5.
Espen Harlinn 9-Apr-12 5:44am    
Thank you Abhinav :-D
 
Share this answer
 
Comments
Nima.naqipoor 8-Apr-12 6:02am    
Cool post,but it's in Ms excel not in Ms Access!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900