Key in record into Access using Excel

amkey04 · October 4th, 2005, 7:02 am

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

spursfan · October 4th, 2005, 9:16 am

i use the csv format and then the access import wizard

afoster · October 4th, 2005, 9:55 am

yes on the whole this is pretty simple - you need to look up ADO in the VB help.....

amkey04 · October 6th, 2005, 8:15 am

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.

gallag · October 10th, 2005, 6:17 pm

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