How to use Excel as a Data Entry Form for Access?

  • Thread starter Thread starter Mac
  • Start date Start date
M

Mac

am a new user to access, and have not ideal what I am
doing. I am trying to set up a form in excel that will
link to access. I have 11 column, but they are not all in
order. Any ideas will be greatly appreciated. Thank you.
..
 
Hi Mac,

There's no simple way of linking a form in Excel to Access. It can be
done but requires considerable knowledge of programming Excel and DAO or
ADO.

Access can however easily import data from an Excel worksheet. This
works well as long as the Excel data is carefully and consistently
entered.
 
use Navicat
do a google search

Mac said:
am a new user to access, and have not ideal what I am
doing. I am trying to set up a form in excel that will
link to access. I have 11 column, but they are not all in
order. Any ideas will be greatly appreciated. Thank you.
.
Click to expand...
 
Back
Top