Page 1 of 1
Key in record into Access using Excel
Posted: October 4th, 2005, 7:02 am
by amkey04
hi,I am trying to create a link between MS Excel and Access where I can use MS Access as my database but MS Excel as my frontend. Can anyone help me on this? Thanks
Key in record into Access using Excel
Posted: October 4th, 2005, 9:16 am
by spursfan
i use the csv format and then the access import wizard
Key in record into Access using Excel
Posted: October 4th, 2005, 9:55 am
by afoster
yes on the whole this is pretty simple - you need to look up ADO in the VB help.....
Key in record into Access using Excel
Posted: October 6th, 2005, 8:15 am
by amkey04
Hi Afoster and Spursfan, thanks for the reply. I will give it a try first. Basically, what I am trying to do is to create a spreadsheet, which allows me to transfer data entered on my spreadsheet to MS Access.
Key in record into Access using Excel
Posted: October 10th, 2005, 6:17 pm
by gallag
Here's an example, using ADO/SQL, of how you can read information from an Access database and display it in Excel:
www.jsgrant.com/tutorials/ado/Transfering data from Excel to Access can be done in the same way, but using an INSERT statement (instead of SELECT). If you don't know SQL, here's an introduction to it:
www.highcroft.com/highcroft/sql_intro.pdfYou'll see, it's really easy...